David Petraeus, who resigned as director of the Central Intelligence Agency after the revelation of an extramarital affair, has been named a visiting professor at Macaulay Honors College at the City University of New York, the school's chancellor said Tuesday.