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

Documentation

• Getting started with Psycopg 3
  • Installation
  • Basic module usage
  • Passing parameters to SQL queries
  • Template string queries
  • Adapting basic Python types
  • Adapting other PostgreSQL types
  • Transactions management
  • Using COPY TO and COPY FROM
  • Differences from psycopg2
• More advanced topics
  • Concurrent operations
  • Static Typing
  • Row factories
  • Connection pools
  • Cursor types
  • Data adaptation configuration
  • Prepared statements
  • Pipeline mode support
• Psycopg 3 API
  • The psycopg module
  • Connection classes
  • Cursor classes
  • COPY-related objects
  • Other top-level objects
  • sql -- SQL string composition
  • rows -- row factory implementations
  • errors -- Package exceptions
  • psycopg_pool -- Connection pool implementations
  • conninfo -- manipulate connection strings
  • adapt -- Types adaptation
  • types -- Types information and adapters
  • abc -- Psycopg abstract classes
  • pq -- libpq wrapper module
  • crdb -- CockroachDB support
  • _dns -- DNS resolution utilities

Release notes

• psycopg release notes
• psycopg_pool release notes

Indices and tables

• 索引

• 模块索引