pgdb — The DB-API Compliant Interface

Contents

• Introduction
• Module functions and constants
  • connect – Open a PostgreSQL connection
  • get/set/reset_typecast – Control the global typecast functions
  • Module constants
  • Errors raised by this module
• Connection – The connection object
  • close – close the connection
  • commit – commit the connection
  • rollback – roll back the connection
  • cursor – return a new cursor object
  • Attributes that are not part of the standard
• Cursor – The cursor object
  • description – details regarding the result columns
  • rowcount – number of rows of the result
  • close – close the cursor
  • execute – execute a database operation
  • executemany – execute many similar database operations
  • callproc – Call a stored procedure
  • fetchone – fetch next row of the query result
  • fetchmany – fetch next set of rows of the query result
  • fetchall – fetch all rows of the query result
  • arraysize - the number of rows to fetch at a time
  • Methods and attributes that are not part of the standard
• Type – Type objects and constructors
  • Type constructors
  • Type objects
• TypeCache – The internal cache for database types
• Remarks on Adaptation and Typecasting
  • Supported data types
  • Adaptation of parameters
  • Typecasting to Python