Psycopg - PostgreSQL database adapter for Python - Psycopg documentation

Psycopg 3 - PostgreSQL database adapter for Python #

Psycopg 3 is a newly designed PostgreSQL database adapter for the Python programming language.

Psycopg 3 presents a familiar interface for everyone who has used Psycopg 2 or any other DB-API 2.0 database adapter, but allows to use more modern PostgreSQL and Python features, such as:

• Asynchronous support

• COPY support from Python objects

• A redesigned connection pool

• Support for static typing

• Server-side parameters binding

• Prepared statements

• Statements pipeline

• Binary communication

• Direct access to the libpq functionalities