Index

_

_wrapped (psycopg2.extensions.ISQLQuote attribute)

A

AbstractConnectionPool (class in psycopg2.pool) adapt() (in module psycopg2.extensions) Adaptation Boolean Creating new adapters Date/Time objects Lists None Objects Strings Tuple dict numbers adapters (in module psycopg2.extensions) apilevel (in module psycopg2) Array Adaptation

arraysize (cursor attribute) AsIs (class in psycopg2.extensions) async (connection attribute) Asynchronous Connection Notifications Autocommit Transaction

B

Backend PID Begin Binary (class in psycopg2.extensions) BINARY (in module psycopg2) Binary string Binary() (in module psycopg2) BINARYARRAY (in module psycopg2.extensions)

Boolean Adaptation Boolean (class in psycopg2.extensions) BOOLEAN (in module psycopg2.extensions) BOOLEANARRAY (in module psycopg2.extensions) bqual (psycopg2.extensions.Xid attribute) Buffer Adaptation bytea Adaptation

C

callproc() (cursor method) cancel() (connection method) channel (psycopg2.extensions.Notify attribute) Client Encoding Logging close() (connection method) (cursor method) (psycopg2.extensions.lobject method) closeall() (psycopg2.pool.AbstractConnectionPool method) closed (connection attribute) (cursor attribute) (psycopg2.extensions.lobject attribute) Commit Prepared Transaction commit() (connection method) connect() (in module psycopg2) Connection Asynchronous Parameters Pooling Status Subclassing connection (built-in class) (class in psycopg2.extensions) (cursor attribute)

Connection status Constants Connection string Constants Connection status Isolation level Poll status Transaction status COPY SQL command copy_expert() (cursor method) copy_from() (cursor method) copy_to() (cursor method) Coroutine Coroutine; Example Cursor Dictionary Logging Named Server side Subclassing namedtuple cursor (built-in class) (class in psycopg2.extensions) cursor() (connection method)

D

Data types Adaptation Additional Creating new adapters INET UUID hstore database (psycopg2.extensions.Xid attribute) DatabaseError DataError DATE (in module psycopg2.extensions) Date objects Adaptation Date() (in module psycopg2) DATEARRAY (in module psycopg2.extensions) DateFromMx (class in psycopg2.extensions) DateFromPy (class in psycopg2.extensions) DateFromTicks() (in module psycopg2) DATETIME (in module psycopg2) DATETIMEARRAY (in module psycopg2.extensions)

Decimal Adaptation DECIMAL (in module psycopg2.extensions) DECIMALARRAY (in module psycopg2.extensions) DECLARE SQL command description (cursor attribute) dict Adaptation DictConnection (class in psycopg2.extras) DictCursor (class in psycopg2.extras) Dictionary Cursor DictRow (class in psycopg2.extras) dsn (connection attribute) DSN (Database Source Name)

E

Encoding Client Mapping encoding (connection attribute) encodings (in module psycopg2.extensions) Error Codes Eventlet

Example Coroutine; Cursor subclass Types adaptation Usage Exceptions Additional DB API In the connection class execute() (cursor method) executemany() (cursor method) export() (psycopg2.extensions.lobject method)

F

FETCH SQL command fetchall() (cursor method) fetchmany() (cursor method) fetchone() (cursor method) fileno() (connection method) filter() (psycopg2.extras.LoggingConnection method) FixedOffsetTimezone (class in psycopg2.tz)

Float Adaptation Float (class in psycopg2.extensions) FLOAT (in module psycopg2.extensions) FLOATARRAY (in module psycopg2.extensions) format_id (psycopg2.extensions.Xid attribute) from_string() (psycopg2.extensions.Xid method)

G

get_backend_pid() (connection method) get_parameter_status() (connection method) get_transaction_status() (connection method) get_wait_callback() (in module psycopg2.extensions) getconn() (psycopg2.pool.AbstractConnectionPool method)

getquoted() (psycopg2.extensions.AsIs method) (psycopg2.extensions.Binary method) (psycopg2.extensions.ISQLQuote method) (psycopg2.extensions.QuotedString method) gevent Greenlet gtrid (psycopg2.extensions.Xid attribute)

H

Host Connection

hstore Data types

I

IN operator INET Data types Inet (class in psycopg2.extras) initialize() (psycopg2.extras.LoggingConnection method) Integer Adaptation INTEGER (in module psycopg2.extensions) INTEGERARRAY (in module psycopg2.extensions) IntegrityError InterfaceError InternalError INTERVAL (in module psycopg2.extensions) Interval objects Adaptation

INTERVALARRAY (in module psycopg2.extensions) IntervalFromMx (class in psycopg2.extensions) IntervalFromPy (class in psycopg2.extensions) isexecuting() (connection method) Isolation level Constants Transaction isolation_level (connection attribute) ISOLATION_LEVEL_AUTOCOMMIT (in module psycopg2.extensions) ISOLATION_LEVEL_READ_COMMITTED (in module psycopg2.extensions) ISOLATION_LEVEL_READ_UNCOMMITTED (in module psycopg2.extensions) ISOLATION_LEVEL_REPEATABLE_READ (in module psycopg2.extensions) ISOLATION_LEVEL_SERIALIZABLE (in module psycopg2.extensions) ISQLQuote (class in psycopg2.extensions)

L

Large objects lastrowid (cursor attribute) LISTEN SQL command Lists Adaptation lobject (class in psycopg2.extensions) lobject() (connection method) LocalTimezone (class in psycopg2.tz)

Logging Client Cursor LoggingConnection (class in psycopg2.extras) LoggingCursor (class in psycopg2.extras) LONGINTEGER (in module psycopg2.extensions) LONGINTEGERARRAY (in module psycopg2.extensions) lookup() (in module psycopg2.errorcodes)

M

MinTimeLoggingConnection (class in psycopg2.extras) MinTimeLoggingCursor (class in psycopg2.extras) mode (psycopg2.extensions.lobject attribute) mogrify() (cursor method) MOVE SQL command Multiprocess Multithread Connection pooling mx.DateTime Adaptation

MXDATE (in module psycopg2.extensions) MXDATEARRAY (in module psycopg2.extensions) MXDATETIME (in module psycopg2.extensions) MXDATETIMEARRAY (in module psycopg2.extensions) MXINTERVAL (in module psycopg2.extensions) MXINTERVALARRAY (in module psycopg2.extensions) MXTIME (in module psycopg2.extensions) MXTIMEARRAY (in module psycopg2.extensions)

N

name (cursor attribute) Named Cursor namedtuple Cursor NamedTupleConnection (class in psycopg2.extras) NamedTupleCursor (class in psycopg2.extras) new_type() (in module psycopg2.extensions) nextset() (cursor method) None Adaptation

notices (connection attribute) Notifications Asynchronous notifies (connection attribute) NOTIFY SQL command Notify (class in psycopg2.extensions) NotSupportedError NULL Adaptation NUMBER (in module psycopg2)

O

Objects Adaptation Creating new adapters oid (psycopg2.extensions.lobject attribute)

OperationalError owner (psycopg2.extensions.Xid attribute)

P

Parameters Connection Query Server paramstyle (in module psycopg2) Password Connection payload (psycopg2.extensions.Notify attribute) PersistentConnectionPool (class in psycopg2.pool) PgBouncer unclean server pgcode (psycopg2.Error attribute) pgerror (psycopg2.Error attribute) PID Backend pid (psycopg2.extensions.Notify attribute) Poll status Constants poll() (connection method) POLL_ERROR (in module psycopg2.extensions) POLL_OK (in module psycopg2.extensions) POLL_READ (in module psycopg2.extensions) POLL_WRITE (in module psycopg2.extensions) Pooling Connection Port Connection Prepare Transaction prepare() (psycopg2.extensions.ISQLQuote method) Prepared Commit Rollback

prepared (psycopg2.extensions.Xid attribute) ProgrammingError Protocol Version protocol_version (connection attribute) psycopg2 (module) psycopg2.errorcodes (module) psycopg2.extensions (module) psycopg2.extras (module) psycopg2.pool (module) psycopg2.tz (module) putconn() (psycopg2.pool.AbstractConnectionPool method) PYDATE (in module psycopg2.extensions) PYDATEARRAY (in module psycopg2.extensions) PYDATETIME (in module psycopg2.extensions) PYDATETIMEARRAY (in module psycopg2.extensions) PYINTERVAL (in module psycopg2.extensions) PYINTERVALARRAY (in module psycopg2.extensions) Python Enhancement Proposals!PEP 246, [1] PYTIME (in module psycopg2.extensions) PYTIMEARRAY (in module psycopg2.extensions)

Q

Query Parameters query (cursor attribute)

QueryCanceledError QuotedString (class in psycopg2.extensions)

R

read() (psycopg2.extensions.lobject method) RealDictConnection (class in psycopg2.extras) RealDictCursor (class in psycopg2.extras) RealDictRow (class in psycopg2.extras) Recover Transaction register_adapter() (in module psycopg2.extensions) register_hstore() (in module psycopg2.extras) register_inet() (in module psycopg2.extras) register_tstz_w_secs() (in module psycopg2.extras)

register_type() (in module psycopg2.extensions) register_uuid() (in module psycopg2.extras) reset() (connection method) Rollback Prepared Transaction rollback() (connection method) rowcount (cursor attribute) ROWID (in module psycopg2) ROWIDARRAY (in module psycopg2.extensions) rownumber (cursor attribute)

S

scroll() (cursor method) Security seek() (psycopg2.extensions.lobject method) Server Parameters Version Server side Cursor server_version (connection attribute) set_client_encoding() (connection method) set_isolation_level() (connection method) set_wait_callback() (in module psycopg2.extensions) setinputsizes() (cursor method) setoutputsize() (cursor method) SimpleConnectionPool (class in psycopg2.pool) SQL command COPY DECLARE FETCH LISTEN MOVE NOTIFY SQL injection

SQL_IN (class in psycopg2.extensions) Status Connection Transaction status (connection attribute) STATUS_BEGIN (in module psycopg2.extensions) STATUS_IN_TRANSACTION (in module psycopg2.extensions) STATUS_PREPARED (in module psycopg2.extensions) STATUS_READY (in module psycopg2.extensions) statusmessage (cursor attribute) STRING (in module psycopg2) string_types (in module psycopg2.extensions) STRINGARRAY (in module psycopg2.extensions) Strings Adaptation Subclassing Connection Cursor

T

tell() (psycopg2.extensions.lobject method) Thread safety ThreadedConnectionPool (class in psycopg2.pool) threadsafety (in module psycopg2) TIME (in module psycopg2.extensions) Time objects Adaptation Time zones Fractional Time Zones Time() (in module psycopg2) TIMEARRAY (in module psycopg2.extensions) TimeFromMx (class in psycopg2.extensions) TimeFromPy (class in psycopg2.extensions) TimeFromTicks() (in module psycopg2) Timestamp() (in module psycopg2) TimestampFromMx (class in psycopg2.extensions) TimestampFromPy (class in psycopg2.extensions) TimestampFromTicks() (in module psycopg2) tpc_begin() (connection method)

tpc_commit() (connection method) tpc_prepare() (connection method) tpc_recover() (connection method) tpc_rollback() (connection method) Transaction Autocommit Commit Isolation level Prepare Recover Rollback Status Two-phase commit Transaction status Constants TRANSACTION_STATUS_ACTIVE (in module psycopg2.extensions) TRANSACTION_STATUS_IDLE (in module psycopg2.extensions) TRANSACTION_STATUS_INERROR (in module psycopg2.extensions) TRANSACTION_STATUS_INTRANS (in module psycopg2.extensions) TRANSACTION_STATUS_UNKNOWN (in module psycopg2.extensions) TransactionRollbackError truncate() (psycopg2.extensions.lobject method) Tuple Adaptation Two-phase commit Transaction methods Type casting tzinfo_factory (cursor attribute)

U

Unicode Adaptation UNICODE (in module psycopg2.extensions) UNICODEARRAY (in module psycopg2.extensions) unlink() (psycopg2.extensions.lobject method)

Usage Example Username Connection UUID Data types UUID_adapter (class in psycopg2.extras)

V

Version Protocol Server

W

Wait callback wait_select() (in module psycopg2.extras)

Warning write() (psycopg2.extensions.lobject method)

X

Xid (class in psycopg2.extensions)

xid() (connection method)