PyPI · #459 most downloaded on PyPI

psycopg2

2.9.1364M downloads/mopsycopg/psycopg2 ↗New releases in your daily digest, changelog included.

psycopg2 - Python-PostgreSQL Database Adapter

Last release 19 days ago
09 Sep 2026
Ships fairly regularly
a new release about every 5 months
Most releases are documented
notes for 52 of the last 60 stable releases
Nothing withdrawn
no release was ever pulled
16 years old
66 releases · first in 2010

Release timeline

66 releases since 2010

2010201220142016

Releases

2.0.73 sources agree
All instances of psycopg2.Error subclasses now have pgerror, pgcode and cursor attributes. They will be set to None if no value is available.
Improved error handling:

All instances of psycopg2.Error subclasses now have pgerror, pgcode and cursor attributes. They will be set to None if no value is available.

Exception classes are now chosen based on the SQLSTATE value from the result. (#184)

The commit() and rollback() methods now set the pgerror and pgcode attributes on exceptions. (#152)

errors from commit() and rollback() are no longer considered fatal. (#194)

If a disconnect is detected during execute(), an exception will be raised at that point rather than resulting in "ProgrammingError: no results to fetch" later on. (#186)

Better PostgreSQL compatibility:

If the server uses standard_conforming_strings, perform appropriate quoting.

BC dates are now handled if psycopg is compiled with mxDateTime support. If using datetime, an appropriate ValueError is raised. (#203)

Other bug fixes:

If multiple sub-interpreters are in use, do not share the Decimal type between them. (#192)

Buffer objects obtained from psycopg are now accepted by psycopg too, without segfaulting. (#209)

A few small changes were made to improve DB-API compatibility. All the dbapi20 tests now pass.

Miscellaneous:

The PSYCOPG_DISPLAY_SIZE option is now off by default. This means that display size will always be set to "None" in cursor.description. Calculating the display size was expensive, and infrequently used so this should improve performance.

New QueryCanceledError and TransactionRollbackError exceptions have been added to the psycopg2.extensions module. They can be used to detect statement timeouts and deadlocks respectively.

Cursor objects now have a "closed" attribute. (#164)

If psycopg has been built with debug support, it is now necessary to set the PSYCOPG_DEBUG environment variable to turn on debug spew.
Open source →

2.0.63 sources agree

Better support for PostgreSQL, Python and win32:

full support for PostgreSQL 8.2, including NULLs in arrays
support for almost all existing PostgreSQL encodings
full list of PostgreSQL error codes available by importing the psycopg2.errorcodes module
full support for Python 2.5 and 64 bit architectures
better build support on win32 platform

Support for per-connection type-casters (used by ZPsycopgDA too, this fixes a long standing bug that made different connections use a random set of date/time type-casters instead of the configured one.)

Better management of times and dates both from Python and in Zope.

copy_to and copy_from now take an extra "columns" parameter.

Python tuples are now adapted to SQL sequences that can be used with the "IN" operator by default if the psycopg2.extensions module is imported (i.e., the SQL_IN adapter was moved from extras to extensions.)

Fixed some small buglets and build glitches:

removed double mutex destroy
removed all non-constant initializers
fixed PyObject_HEAD declarations to avoid memory corruption on 64 bit architectures
fixed several Python API calls to work on 64 bit architectures
applied compatibility macros from PEP 353
now using more than one argument format raise an error instead of a segfault

Open source →