Add psycopg2 type overrides to DBAPI

Why doesn't this one have to worry about None?