[psycopg2] Annotate some connection argument and return types (#15704)

[psycopg2] Annotate some connection argument and return types (#15704) #15114