Psycopg is the most popular PostgreSQL adapter for the Python programming language. Its core is a complete implementation of the Python DB API 2.0 specifications. Several extensions allow access to many of the features offered by PostgreSQL.

Psycopg is released under the terms of the GNU Lesser General Public License, allowing use from both free and proprietary software.

Check the features list to see what Psycopg offers
Read the Psycopg documentation. Be sure to check the Frequently Asked Questions
Install Psycopg!

For help requests and development discussions please subscribe to the mailing list psycopg@postgresql.org.

Latest articles

Psycopg 2.8.4 released

Psycopg 2.8.4 has been released.

The release brings a few assorted bugfixes and adds support for Python 3.8 and PostgreSQL 12.

Psycopg 2.8.3 released

We have released Psycopg 2.8.3, which includes a slight change to the logical replication.

Choosing the right frequency to send replication feedback messages from the client to the server was previously the developer's responsibility, with too many feedback messages being a waste of bandwidth and server resources, too few slowing down WAL cleanup and possibly preventing a server graceful shutdown.

Psycopg 2.8.1, 2.8.2 released

Hello,

We have just released Psycopg 2.8.2; a few days ago Psycopg 2.8.1 was released.

Some of the bugs addressed are ordinary teething problem with the 2.8 release, but an important change landed with 2.8.2: binary packages now ship with OpenSSL 1.1 instead of 1.0. This should fix concurrency problems on connection experienced both on Windows and Linux. Many thanks to Matthew Brett and Jason Erickson for this improvement!