Psycopg 3 API

This sections is a reference for all the public objects exposed by the psycopg module. For a more conceptual description you can take a look at 開始使用 Psycopg 3 and 更進階的話題.

Contents:

• The psycopg module
  • connect()
  • capabilities
  • adapters
• Connection 類別
  • The Connection class
  • The AsyncConnection class
• Cursor classes
  • Cursor 類別
  • ClientCursor 類別
  • ServerCursor 類別
  • RawCursor 和 RawServerCursor 類別
  • Async cursor classes
• COPY-related objects
  • Main Copy objects
  • Writer objects
• Other top-level objects
  • Connection information
  • Libpq capabilities information
  • The description Column object
  • Notifications
  • Pipeline-related objects
  • Transaction-related objects
  • Two-Phase Commit related objects
• sql -- SQL string composition
  • Module usage
  • sql objects
  • Utility functions
• rows -- row factory implementations
  • tuple_row()
  • dict_row()
  • namedtuple_row()
  • scalar_row()
  • class_row()
  • args_row()
  • kwargs_row()
  • Formal rows protocols
• errors -- Package exceptions
  • DB-API exceptions
  • Error diagnostics
  • SQLSTATE exceptions
• psycopg_pool -- Connection pool implementations
  • The ConnectionPool class
  • Pool exceptions
  • AsyncConnectionPool 類別
  • Null connection pools
• conninfo -- manipulate connection strings
  • conninfo_to_dict()
  • make_conninfo()
• adapt -- Types adaptation
  • Dumpers and loaders
  • Other objects used in adaptations
• types -- Types information and adapters
  • 型別資訊
  • JSON adapters
• abc -- Psycopg 抽象類別
  • Dumper
  • Loader
  • AdaptContext
• pq -- libpq wrapper module
  • pq module implementations
  • Module content
  • Objects wrapping libpq structures and functions
  • Enumerations
• crdb -- CockroachDB 支援
  • Main differences from PostgreSQL
  • CockroachDB-specific objects
• _dns -- DNS resolution utilities
  • resolve_srv()
  • resolve_srv_async()
  • Connection._get_connection_params()
  • AsyncConnection._get_connection_params()
  • resolve_hostaddr_async()