Navigation

  • index
  • modules |
  • next |
  • previous |
  • PyGreSQL 5.2.3 »
  • The PyGreSQL documentation »
  • pgdb — The DB-API Compliant Interface

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

Logo

Table of Contents

  • pgdb — The DB-API Compliant Interface
    • Contents

Previous topic

Remarks on Adaptation and Typecasting

Next topic

Introduction

This Page

  • Show Source

Quick search

Navigation

  • index
  • modules |
  • next |
  • previous |
  • PyGreSQL 5.2.3 »
  • The PyGreSQL documentation »
  • pgdb — The DB-API Compliant Interface
© Copyright 2022, The PyGreSQL team. Created using Sphinx 3.5.2.