pgdb — The DB-API Compliant Interface

Contents

• Introduction
• Module functions and constants
  • connect – Open a PostgreSQL connection
    • connect()
  • get/set/reset_typecast – Control the global typecast functions
    • get_typecast()
    • set_typecast()
    • reset_typecast()
  • Module constants
    • apilevel
    • threadsafety
    • paramstyle
  • Errors raised by this module
    • Warning
    • Error
    • InterfaceError
    • DatabaseError
    • DataError
    • OperationalError
    • IntegrityError
    • ProgrammingError
    • NotSupportedError
• Connection – The connection object
  • Connection
  • close – close the connection
    • Connection.close()
  • commit – commit the connection
    • Connection.commit()
  • rollback – roll back the connection
    • Connection.rollback()
  • cursor – return a new cursor object
    • Connection.cursor()
  • Attributes that are not part of the standard
    • Connection.closed
    • Connection.cursor_type
    • Connection.type_cache
    • Connection.autocommit
• Cursor – The cursor object
  • Cursor
  • description – details regarding the result columns
    • Cursor.description
  • rowcount – number of rows of the result
    • Cursor.rowcount
  • close – close the cursor
    • Cursor.close()
  • execute – execute a database operation
    • Cursor.execute()
  • executemany – execute many similar database operations
    • Cursor.executemany()
  • callproc – Call a stored procedure
  • fetchone – fetch next row of the query result
    • Cursor.fetchone()
  • fetchmany – fetch next set of rows of the query result
    • Cursor.fetchmany()
  • fetchall – fetch all rows of the query result
    • Cursor.fetchall()
  • arraysize - the number of rows to fetch at a time
    • Cursor.arraysize
  • Methods and attributes that are not part of the standard
    • Cursor.copy_from()
    • Cursor.copy_to()
    • Cursor.row_factory()
    • Cursor.build_row_factory()
    • Cursor.colnames
    • Cursor.coltypes
• Type – Type objects and constructors
  • Type constructors
    • Date()
    • Time()
    • Timestamp()
    • DateFromTicks()
    • TimeFromTicks()
    • TimestampFromTicks()
    • Binary()
    • Interval()
    • Uuid()
    • Hstore()
    • Json()
    • Literal()
  • Type objects
    • DbType
• TypeCache – The internal cache for database types
  • TypeCache
  • TypeCache.get_fields()
  • TypeCache.get_typecast()
  • TypeCache.set_typecast()
  • TypeCache.reset_typecast()
  • TypeCache.typecast()
• Remarks on Adaptation and Typecasting
  • Supported data types
  • Adaptation of parameters
  • Typecasting to Python