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 JSON Lists None Objects Strings Tuple dict namedtuple numbers tuple adapter (psycopg2.extras.RangeCaster attribute) adapters (in module psycopg2.extensions) apilevel (in module psycopg2) ARCHFLAGS Array Adaptation array_oid (psycopg2.extras.CompositeCaster attribute)

array_typecaster (psycopg2.extras.RangeCaster attribute) arraysize (cursor attribute) AsIs (class in psycopg2.extensions) async (connection attribute) Asynchronous Connection Notifications attnames (psycopg2.extras.CompositeCaster attribute) atttypes (psycopg2.extras.CompositeCaster attribute) Autocommit Transaction autocommit (connection attribute)

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 bytearray Adaptation bytes Adaptation

C

callproc() (cursor method) cancel() (connection method) cast() (cursor 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) column_name (psycopg2.extensions.Diagnostics attribute) Commit Prepared Transaction commit() (connection method) Composite types Data types CompositeCaster (class in psycopg2.extras) 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 constraint_name (psycopg2.extensions.Diagnostics attribute) context (psycopg2.extensions.Diagnostics attribute) 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) (psycopg2.Error attribute) cursor() (connection method) cursor_factory (connection attribute)

D

Data types Adaptation Additional Composite types Creating new adapters INET JSON UUID hstore range database (psycopg2.extensions.Xid attribute) DatabaseError DataError datatype_name (psycopg2.extensions.Diagnostics attribute) DATE (in module psycopg2.extensions) Date objects Adaptation Infinite Date() (in module psycopg2) DATEARRAY (in module psycopg2.extensions) DateFromMx (class in psycopg2.extensions) DateFromPy (class in psycopg2.extensions) DateFromTicks() (in module psycopg2) DateRange (class in psycopg2.extras) DATETIME (in module psycopg2) DATETIMEARRAY (in module psycopg2.extensions) DateTimeRange (class in psycopg2.extras) DateTimeTZRange (class in psycopg2.extras)

debug Decimal Adaptation DECIMAL (in module psycopg2.extensions) DECIMALARRAY (in module psycopg2.extensions) DECLARE SQL command description (cursor attribute) diag (psycopg2.Error attribute) Diagnostics (class in psycopg2.extensions) 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) dumps() (psycopg2.extras.Json method)

E

Encoding Client Mapping encoding (connection attribute) encodings (in module psycopg2.extensions) environment variable ARCHFLAGS LD_LIBRARY_PATH PATH, [1], [2], [3] PSYCOPG2_TESTDB PSYCOPG2_TESTDB_HOST PSYCOPG2_TESTDB_PORT PSYCOPG2_TESTDB_USER PSYCOPG_DEBUG PSYCOPG_DISPLAY_SIZE PYTHON_EGG_CACHE standard_conforming_string 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 static 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) Infinite Date objects initialize() (psycopg2.extras.LoggingConnection method) Install Linux Mac OS X Windows from PyPI from source Integer Adaptation INTEGER (in module psycopg2.extensions) INTEGERARRAY (in module psycopg2.extensions) IntegrityError InterfaceError internal_position (psycopg2.extensions.Diagnostics attribute) internal_query (psycopg2.extensions.Diagnostics attribute) InternalError INTERVAL (in module psycopg2.extensions)

Interval objects Adaptation INTERVALARRAY (in module psycopg2.extensions) IntervalFromMx (class in psycopg2.extensions) IntervalFromPy (class in psycopg2.extensions) isempty (psycopg2.extras.Range attribute) 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) itersize (cursor attribute)

J

JSON Adaptation Data types

Json (class in psycopg2.extras)

L

Large objects lastrowid (cursor attribute) LD_LIBRARY_PATH Linux Install 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) lower (psycopg2.extras.Range attribute) lower_inc (psycopg2.extras.Range attribute) lower_inf (psycopg2.extras.Range attribute)

M

Mac OS X Install make() (psycopg2.extras.CompositeCaster method) memoryview Adaptation message_detail (psycopg2.extensions.Diagnostics attribute) message_hint (psycopg2.extensions.Diagnostics attribute) message_primary (psycopg2.extensions.Diagnostics attribute) 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) (psycopg2.extras.CompositeCaster attribute) Named Cursor namedtuple Adaptation Cursor NamedTupleConnection (class in psycopg2.extras) NamedTupleCursor (class in psycopg2.extras) new_array_type() (in module psycopg2.extensions) 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) NumericRange (class in psycopg2.extras)

O

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

OperationalError owner (psycopg2.extensions.Xid attribute)

P

Parameters Connection Query Server paramstyle (in module psycopg2) Password Connection PATH, [1], [2], [3] 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) PSYCOPG2_TESTDB PSYCOPG2_TESTDB_HOST PSYCOPG2_TESTDB_PORT PSYCOPG2_TESTDB_USER PSYCOPG_DEBUG, [1] PSYCOPG_DISPLAY_SIZE 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] PYTHON_EGG_CACHE PYTIME (in module psycopg2.extensions) PYTIMEARRAY (in module psycopg2.extensions)

Q

Query Parameters query (cursor attribute)

QueryCanceledError QuotedString (class in psycopg2.extensions)

R

range Data types Range (class in psycopg2.extras) range (psycopg2.extras.RangeCaster attribute) RangeCaster (class in psycopg2.extras) Read only 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_composite() (in module psycopg2.extras) register_default_json() (in module psycopg2.extras) register_default_jsonb() (in module psycopg2.extras)

register_hstore() (in module psycopg2.extras) register_inet() (in module psycopg2.extras) register_json() (in module psycopg2.extras) register_range() (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

schema (psycopg2.extras.CompositeCaster attribute) schema_name (psycopg2.extensions.Diagnostics attribute) scroll() (cursor method) scrollable (cursor attribute) 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_session() (connection method) set_wait_callback() (in module psycopg2.extensions) setinputsizes() (cursor method) setoutputsize() (cursor method) setup.cfg setup.py severity (psycopg2.extensions.Diagnostics attribute) SimpleConnectionPool (class in psycopg2.pool) source_file (psycopg2.extensions.Diagnostics attribute)

source_function (psycopg2.extensions.Diagnostics attribute) source_line (psycopg2.extensions.Diagnostics attribute) SQL command COPY DECLARE FETCH LISTEN MOVE NOTIFY SQL injection SQL_IN (class in psycopg2.extensions) sqlstate (psycopg2.extensions.Diagnostics attribute) standard_conforming_string statement_position (psycopg2.extensions.Diagnostics attribute) 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

table_name (psycopg2.extensions.Diagnostics attribute) tell() (psycopg2.extensions.lobject method) tests Thread safety ThreadedConnectionPool (class in psycopg2.pool) threadsafety (in module psycopg2) TIME (in module psycopg2.extensions) Time objects Adaptation Time Zones Time zones Fractional 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 tuple Adaptation Two-phase commit Transaction methods type (psycopg2.extras.CompositeCaster attribute) Type casting typecaster (psycopg2.extras.RangeCaster attribute) tzinfo_factory (cursor attribute)

U

Unicode Adaptation UNICODE (in module psycopg2.extensions) UNICODEARRAY (in module psycopg2.extensions) unlink() (psycopg2.extensions.lobject method) upper (psycopg2.extras.Range attribute) upper_inc (psycopg2.extras.Range attribute)

upper_inf (psycopg2.extras.Range attribute) 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 Windows Install

with statement withhold (cursor attribute) write() (psycopg2.extensions.lobject method)

X

Xid (class in psycopg2.extensions)

xid() (connection method)