=================================================== 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:

• :ref:Asynchronous support <async>
• :ref:COPY support from Python objects <copy>
• :ref:A redesigned connection pool <connection-pools>
• :ref:Support for static typing <static-typing>
• :ref:Server-side parameters binding <server-side-binding>
• :ref:Prepared statements <prepared-statements>
• :ref:Statements pipeline <pipeline-mode>
• :ref:Binary communication <binary-data>
• :ref:Direct access to the libpq functionalities <psycopg.pq>

.. _Python: https://www.python.org/ .. _PostgreSQL: https://www.postgresql.org/ .. _Psycopg 2: https://www.psycopg.org/docs/ .. _DB-API 2.0: https://www.python.org/dev/peps/pep-0249/

Documentation

.. toctree:: :maxdepth: 2

basic/index
advanced/index
api/index

Release notes

.. toctree:: :maxdepth: 1

news
news_pool

Indices and tables

• :ref:genindex
• :ref:modindex