postgresql: Add type annotation for 'db' argument

This allows mypy to actually type-check calls to db methods.

This commit also fixes an issue found by mypy.