Add psycopg2 type overrides to DBAPI

Up to you though, feel free to take them out or leave them in.