You may either choose to use the “classic” PyGreSQL interface provided by the pg module or else the newer DB-API 2.0 compliant interface provided by the pgdb module.

The following part of the documentation covers only the newer pgdb API.

DB-API 2.0 (Python Database API Specification v2.0) is a specification for connecting to databases (not only PostgreSQL) from Python that has been developed by the Python DB-SIG in 1999. The authoritative programming information for the DB-API is PEP 0249.

See also

A useful tutorial-like introduction to the DB-API has been written by Andrew M. Kuchling for the LINUX Journal in 1998.