Navigation : Psycopg - PostgreSQL database adapter for Python - Psycopg 2.7.6 documentation > Index - Psycopg 2.7.6 documentation Index - Psycopg 2.7.6 documentation Navigation index modules Psycopg 2.7.6 documentation Index _ A B C D E F G H I J L M N O P Q R S T U V W X _ __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 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) 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 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) 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_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 Parameters , [1] Pooling Status Subclassing replication 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) 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 Replication Server side Subclassing namedtuple replication 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 INET JSON MACADDR UUID hstore range 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) 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 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) drop_replication_slot() (psycopg2.extras.ReplicationCursor method) 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) execute_batch() (in module psycopg2.extras) execute_values() (in module psycopg2.extras) executemany() (cursor method) export() (psycopg2.extensions.lobject method) F 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_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 Identifier (class in psycopg2.sql) IN operator INET Data types Inet (class in psycopg2.extras) Infinite Date objects 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) InternalError INTERVAL (in module psycopg2.extensions) Interval objects Adaptation INTERVALARRAY (in module psycopg2.extensions) IntervalFromMx (class in 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) 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) 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) MXDATETIMETZ (in module psycopg2.extensions) MXDATETIMETZARRAY (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) (psycopg2.sql.Placeholder 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) 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 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 , [1] Query Server paramstyle (in module psycopg2) parse_dsn() (in module psycopg2.extensions) Password Connection PATH , [1] , [2] , [3] payload (psycopg2.extensions.Notify attribute) (psycopg2.extras.ReplicationMessage attribute) PersistentConnectionPool (class in psycopg2.pool) PgBouncer unclean server pgcode (psycopg2.Error attribute) pgerror (psycopg2.Error 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 Prepare Transaction prepare() (psycopg2.extensions.ISQLQuote method) Prepared Commit Rollback prepared (psycopg2.extensions.Xid attribute) Prerequisites ProgrammingError Protocol Version protocol_version (connection attribute) psycopg2 (module) psycopg2.errorcodes (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] 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) 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] 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_tstz_w_secs() (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 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) 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 (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) 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) 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.Identifier attribute) (psycopg2.sql.SQL attribute) 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) wal_end (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) Navigation index modules Psycopg 2.7.6 documentation