Index

_

__libpq_version__ (in module psycopg2)

_wrapped (psycopg2.extensions.ISQLQuote attribute)

A

AbstractConnectionPool (class in psycopg2.pool) adapt() (in module psycopg2.extensions) Adaptation Boolean Creating new adapters Date/Time objects dict JSON Lists namedtuple None numbers Objects Strings tuple 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) as_string() (psycopg2.sql.Composable method) AsIs (class in psycopg2.extensions) async (connection attribute) async_ (connection attribute) Asynchronous Connection Notifications attnames (psycopg2.extras.CompositeCaster attribute) atttypes (psycopg2.extras.CompositeCaster attribute) Autocommit Transaction autocommit (connection attribute)

B

Backend PID backend_pid (psycopg2.extensions.ConnectionInfo attribute) 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 BYTES (in module psycopg2.extensions) BYTESARRAY (in module psycopg2.extensions)

C

callproc() (cursor method) cancel() (connection method) cast() (cursor method) channel (psycopg2.extensions.Notify attribute) CIDR Data types 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 (class in psycopg2.extensions) column_name (psycopg2.extensions.Diagnostics attribute) Commit Prepared Transaction commit() (connection method) Composable (class in psycopg2.sql) Composed (class in psycopg2.sql) Composite types Data types CompositeCaster (class in psycopg2.extras) connect() (in module psycopg2) Connection Asynchronous Info Parameters, [1] Pooling replication Status Subclassing connection (built-in class) (class in psycopg2.extensions) (cursor attribute)

Connection status Constants Connection string ConnectionInfo (class in psycopg2.extensions) Constants Connection status Isolation level Poll status Transaction status constraint_name (psycopg2.extensions.Diagnostics attribute) consume_stream() (psycopg2.extras.ReplicationCursor method) context (psycopg2.extensions.Diagnostics attribute) COPY SQL command copy_expert() (cursor method) copy_from() (cursor method) copy_to() (cursor method) Coroutine Coroutine; Example create_replication_slot() (psycopg2.extras.ReplicationCursor method) Cursor Dictionary Logging Named namedtuple replication Replication Server side Subclassing cursor (built-in class) (class in psycopg2.extensions) (psycopg2.Error attribute) (psycopg2.extras.ReplicationMessage attribute) cursor() (connection method) cursor_factory (connection attribute)

D

Data types Adaptation Additional CIDR Composite types Creating new adapters hstore INET JSON MACADDR range UUID data_size (psycopg2.extras.ReplicationMessage attribute) data_start (psycopg2.extras.ReplicationMessage attribute) 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) 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) dbname (psycopg2.extensions.ConnectionInfo attribute) debug Decimal Adaptation DECIMAL (in module psycopg2.extensions) DECIMALARRAY (in module psycopg2.extensions) DECLARE SQL command deferrable (connection attribute) 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) display_size (psycopg2.extensions.Column attribute) drop_replication_slot() (psycopg2.extras.ReplicationCursor method) dsn (connection attribute) DSN (Database Source Name) dsn_parameters (psycopg2.extensions.ConnectionInfo attribute) dumps() (psycopg2.extras.Json method)

E

Encoding Client Mapping encoding (connection attribute) encodings (in module psycopg2.extensions) encrypt_password() (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 PYTHON_EGG_CACHE standard_conforming_string Error Class Codes

error_message (psycopg2.extensions.ConnectionInfo attribute) Eventlet Example Coroutine; Cursor subclass Types adaptation Usage Exceptions Additional DB API In the connection class execute() (cursor method) execute_batch() (in module psycopg2.extras) execute_values() (in module psycopg2.extras) executemany() (cursor method) export() (psycopg2.extensions.lobject method)

F

feedback_timestamp (psycopg2.extras.ReplicationCursor attribute) FETCH SQL command fetchall() (cursor method) fetchmany() (cursor method) fetchone() (cursor method) fileno() (connection method) (psycopg2.extras.ReplicationCursor method) filter() (psycopg2.extras.LoggingConnection method) (psycopg2.extras.MinTimeLoggingConnection method)

FixedOffsetTimezone (class in psycopg2.tz) Float Adaptation Float (class in psycopg2.extensions) FLOAT (in module psycopg2.extensions) FLOATARRAY (in module psycopg2.extensions) format() (psycopg2.sql.SQL method) format_id (psycopg2.extensions.Xid attribute) from_string() (psycopg2.extensions.Xid static method)

G

get_backend_pid() (connection method) get_dsn_parameters() (connection method) get_native_connection() (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

host (psycopg2.extensions.ConnectionInfo attribute) hstore Data types

I

Identifier (class in psycopg2.sql) IN operator INET Data types Inet (class in psycopg2.extras) Infinite Date objects Info Connection info (connection attribute) initialize() (psycopg2.extras.LoggingConnection method) (psycopg2.extras.MinTimeLoggingConnection method) Install disable wheel from PyPI wheel 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) internal_size (psycopg2.extensions.Column attribute) InternalError INTERVAL (in module psycopg2.extensions) Interval objects Adaptation INTERVALARRAY (in module psycopg2.extensions) IntervalFromPy (class in psycopg2.extensions) io_timestamp (psycopg2.extras.ReplicationCursor attribute) 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_DEFAULT (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

join() (psycopg2.sql.Composed method) (psycopg2.sql.SQL method) JSON Adaptation Data types

Json (class in psycopg2.extras)

L

Large objects lastrowid (cursor attribute) LD_LIBRARY_PATH libpq_version() (in module psycopg2.extensions) License LISTEN SQL command Lists Adaptation Literal (class in psycopg2.sql) 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) LogicalReplicationConnection (class in psycopg2.extras) LONGINTEGER (in module psycopg2.extensions) LONGINTEGERARRAY (in module psycopg2.extensions) lookup() (in module psycopg2.errorcodes) (in module psycopg2.errors) lower (psycopg2.extras.Range attribute) lower_inc (psycopg2.extras.Range attribute) lower_inf (psycopg2.extras.Range attribute)

M

MACADDR Data types make() (psycopg2.extras.CompositeCaster method) make_dsn() (in module psycopg2.extensions) memoryview Adaptation Message replication 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)

module psycopg2 psycopg2.errorcodes psycopg2.errors psycopg2.extensions psycopg2.extras psycopg2.pool psycopg2.sql psycopg2.tz mogrify() (cursor method) MOVE SQL command Multiprocess Multithread Connection pooling

N

name (cursor attribute) (psycopg2.extensions.Column attribute) (psycopg2.extras.CompositeCaster attribute) (psycopg2.sql.Placeholder attribute) Named Cursor namedtuple Adaptation Cursor NamedTupleConnection (class in psycopg2.extras) NamedTupleCursor (class in psycopg2.extras) needs_password (psycopg2.extensions.ConnectionInfo attribute) new_array_type() (in module psycopg2.extensions) new_type() (in module psycopg2.extensions) News

nextset() (cursor method) None Adaptation notices (connection attribute) Notifications Asynchronous notifies (connection attribute) NOTIFY SQL command Notify (class in psycopg2.extensions) NotSupportedError NULL Adaptation null_ok (psycopg2.extensions.Column attribute) 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 options (psycopg2.extensions.ConnectionInfo attribute) owner (psycopg2.extensions.Xid attribute)

P

parameter_status() (psycopg2.extensions.ConnectionInfo method) Parameters Connection, [1] Query Server paramstyle (in module psycopg2) parse_dsn() (in module psycopg2.extensions) Password Connection password (psycopg2.extensions.ConnectionInfo attribute) PATH, [1], [2], [3] payload (psycopg2.extensions.Notify attribute) (psycopg2.extras.ReplicationMessage attribute) PgBouncer unclean server pgcode (psycopg2.Error attribute) pgconn_ptr (connection attribute) pgerror (psycopg2.Error attribute) pgresult_ptr (cursor attribute) PhysicalReplicationConnection (class in psycopg2.extras) PID Backend pid (psycopg2.extensions.Notify attribute) Placeholder (class in psycopg2.sql) 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 port (psycopg2.extensions.ConnectionInfo attribute) precision (psycopg2.extensions.Column attribute) Prepare Transaction prepare() (psycopg2.extensions.ISQLQuote method) Prepared Commit Rollback

prepared (psycopg2.extensions.Xid attribute) Prerequisites ProgrammingError Protocol Version protocol_version (connection attribute) (psycopg2.extensions.ConnectionInfo attribute) psycopg2 module psycopg2.errorcodes module psycopg2.errors module psycopg2.extensions module psycopg2.extras module psycopg2.pool module psycopg2.sql module psycopg2.tz module PSYCOPG2_TESTDB PSYCOPG2_TESTDB_HOST PSYCOPG2_TESTDB_PORT PSYCOPG2_TESTDB_USER PSYCOPG_DEBUG, [1] 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) PYDATETIMETZ (in module psycopg2.extensions) PYDATETIMETZARRAY (in module psycopg2.extensions) PYINTERVAL (in module psycopg2.extensions) PYINTERVALARRAY (in module psycopg2.extensions) Python Enhancement Proposals PEP 246, [1] PEP 599 PEP 600 PYTHON_EGG_CACHE PYTIME (in module psycopg2.extensions) PYTIMEARRAY (in module psycopg2.extensions)

Q

Query Parameters query (cursor attribute)

QueryCanceledError quote_ident() (in module psycopg2.extensions) 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) read_message() (psycopg2.extras.ReplicationCursor method) readonly (connection attribute) 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_ipaddress() (in module psycopg2.extras) register_json() (in module psycopg2.extras)

register_range() (in module psycopg2.extras) register_type() (in module psycopg2.extensions) register_uuid() (in module psycopg2.extras) Release notes Replication Cursor replication Connection Cursor Message REPLICATION_LOGICAL (in module psycopg2.extras) REPLICATION_PHYSICAL (in module psycopg2.extras) ReplicationCursor (class in psycopg2.extras) ReplicationMessage (class in 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

scale (psycopg2.extensions.Column attribute) schema (psycopg2.extras.CompositeCaster attribute) schema_name (psycopg2.extensions.Diagnostics attribute) scroll() (cursor method) scrollable (cursor attribute) Security seek() (psycopg2.extensions.lobject method) send_feedback() (psycopg2.extras.ReplicationCursor method) send_time (psycopg2.extras.ReplicationMessage attribute) seq (psycopg2.sql.Composed attribute) Server Parameters Version Server side Cursor server_version (connection attribute) (psycopg2.extensions.ConnectionInfo 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) severity_nonlocalized (psycopg2.extensions.Diagnostics attribute) SimpleConnectionPool (class in psycopg2.pool) socket (psycopg2.extensions.ConnectionInfo attribute) source_file (psycopg2.extensions.Diagnostics attribute) source_function (psycopg2.extensions.Diagnostics attribute) source_line (psycopg2.extensions.Diagnostics attribute) SQL (class in psycopg2.sql) SQL command COPY DECLARE FETCH LISTEN MOVE NOTIFY

SQL injection SQL_IN (class in psycopg2.extensions) sqlstate (psycopg2.extensions.Diagnostics attribute) ssl_attribute() (psycopg2.extensions.ConnectionInfo method) ssl_attribute_names (psycopg2.extensions.ConnectionInfo attribute) ssl_in_use (psycopg2.extensions.ConnectionInfo attribute) standard_conforming_string start_replication() (psycopg2.extras.ReplicationCursor method) start_replication_expert() (psycopg2.extras.ReplicationCursor method) statement_position (psycopg2.extensions.Diagnostics attribute) Status Connection Transaction status (connection attribute) (psycopg2.extensions.ConnectionInfo 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) StopReplication (class in psycopg2.extras) STRING (in module psycopg2) string (psycopg2.sql.SQL attribute) string_types (in module psycopg2.extensions) STRINGARRAY (in module psycopg2.extensions) Strings Adaptation strings (psycopg2.sql.Identifier attribute) Subclassing Connection Cursor

T

table_column (psycopg2.extensions.Column attribute) table_name (psycopg2.extensions.Diagnostics attribute) table_oid (psycopg2.extensions.Column 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() (in module psycopg2) TIMEARRAY (in module psycopg2.extensions) TimeFromPy (class in psycopg2.extensions) TimeFromTicks() (in module psycopg2) Timestamp() (in module psycopg2) 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 (psycopg2.extensions.ConnectionInfo attribute) 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 methods Transaction type (psycopg2.extras.CompositeCaster attribute) Type casting type_code (psycopg2.extensions.Column attribute) 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 used_password (psycopg2.extensions.ConnectionInfo attribute) user (psycopg2.extensions.ConnectionInfo attribute) Username Connection UUID Data types UUID_adapter (class in psycopg2.extras)

V

Version Protocol Server

W

Wait callback wait_select() (in module psycopg2.extras) wal_end (psycopg2.extras.ReplicationCursor attribute) (psycopg2.extras.ReplicationMessage attribute) Warning

Wheel disable with statement withhold (cursor attribute) wrapped (psycopg2.sql.Literal attribute) write() (psycopg2.extensions.lobject method)

X

Xid (class in psycopg2.extensions)

xid() (connection method)