psycopg2
is one of the most popular PostgreSQL drivers for Python. It is compliant to the Python's DB API 2.0 specification. It is mostly implemented in C and uses the library, libpq
. It is thread safe, which means that you can share the same connection
object between several threads. It can work both with Python 2 and Python 3.
The official web page of the library is located at http://initd.org/psycopg/.
The driver psycopg2
can be installed with PIP on Linux from the command line as follows:
user@host:~$ sudo pip3 install psycopg2 [sudo] password for user: Collecting psycopg2 Downloading psycopg2-2.7.3.1-cp35-cp35m-manylinux1_x86_64.whl (2.6MB) 100% |████████████████████████████████| 2.6MB 540kB/s Installing collected packages: psycopg2 Successfully installed psycopg2-2.7.3.1
Type this in Windows from the command line:
C:\Users\User>python -m pip install psycopg2 Collecting psycopg2 Downloading psycopg2-2.7.3.1-cp35-cp35m-win_amd64.whl (943kB)...