Add psycopg2 type overrides to DBAPI

These look like they should also check for None