databases/postgresql1{3,4,5,6,7}-client: Recommend py-psycopg over py-psycopg2

Upstream Python package maintainers recommend using the psycopg 3.x over
psycopg2 for new projects since the latter is in maintenance mode only.

Approved by: girgen (pgsql)
Differential Revision: https://reviews.freebsd.org/D48493

(cherry picked from commit 0eb165a891385d618004882fe24568bc04fac4fc)