Add psycopg2 type overrides to DBAPI

I don't think it's possible for b to be None here, since adapt_buffer is only called when type(b) is buffer. My recall of python's typing/None stuff is not the best though, so feel free to correct me on that.