開始使用 Psycopg 3

This section of the documentation will explain how to install Psycopg and how to perform normal activities such as querying the database or loading data using COPY.

重要

If you are familiar with psycopg2 please take a look at Differences from psycopg2 to see what is changed.

Contents:

• Installation
  • Supported systems
  • What to install?
  • Binary installation
  • Local installation
  • Pure Python installation
  • Installing the connection pool
  • Handling dependencies
• Basic module usage
  • Main objects in Psycopg 3
  • Shortcuts
  • Connection context
  • Adapting psycopg to your program
  • Connection logging
• 將參數傳遞給 SQL 查詢
  • execute() arguments
  • Danger: SQL injection
  • Binary parameters and results
• 模板字串查詢
  • Format specifiers
  • Example: NOTIFY
  • Example: nested templates
• 適配基本的 Python 型別
  • Booleans adaptation
  • Numbers adaptation
  • Strings adaptation
  • Binary adaptation
  • Date/time types adaptation
  • JSON adaptation
  • Lists adaptation
  • UUID adaptation
  • Network data types adaptation
  • Enum adaptation
• 適配其他 PostgreSQL 型別
  • Composite types adaptation
  • Range adaptation
  • Multirange adaptation
  • Hstore adaptation
  • Geometry adaptation using Shapely
• Transactions management
  • Autocommit transactions
  • Transaction contexts
  • Transaction characteristics
  • Two-Phase Commit protocol support
• 使用 COPY TO 與 COPY FROM
  • Writing data row-by-row
  • Reading data row-by-row
  • Copying block-by-block
  • Binary copy
  • 異步複製支援
  • Example: copying a table across servers
• Differences from psycopg2
  • Which package to install?
  • Server-side binding
  • Extended query Protocol
  • Multiple statements in the same query
  • Multiple results returned from multiple statements
  • Different cast rules
  • You cannot use IN %s with a tuple
  • You cannot use IS %s
  • Cursors subclasses
  • Different adaptation system
  • Copy is no longer file-based
  • with connection
  • callproc() is gone
  • client_encoding is gone
  • Transaction characteristics attributes don't affect autocommit sessions
  • No default infinity dates handling
  • What's new in Psycopg 3