Psycopg 2 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 libpq library. 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 psycopg2 driver 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% |███████████████████████...