In my case I have python 3.10.10 with pip 22.0.4 and I do not have errors with the package psycopg2. Good luck.
psycopg2