[Python] ImportError "no pq wrapper available" when importing psycopg3

I installed pyscopg3 on my venv using pip install psycopg[binary] as per the documentation but I still get an import error:

Exception has occurred: ImportError
no pq wrapper available.
Attempts made:
- couldn't import psycopg 'c' implementation: No module named 'psycopg_c'
- couldn't import psycopg 'binary' implementation: DLL load failed while importing pq: The specified module could not be found.
- couldn't import psycopg 'python' implementation: libpq library not found


I'm running a Windows 10 machine. How can I solve this error?

Continue reading...