Index

Symbols

``with`` Connection

_

__build_version__ (in module psycopg.pq) __call__() (psycopg.rows.RowFactory method) (psycopg.rows.RowMaker method) __getitem__() (psycopg.types.TypesRegistry method)

__impl__ (in module psycopg.pq) _get_connection_params() (psycopg.AsyncConnection class method) (psycopg.Connection class method) _query (psycopg.Cursor attribute)

A

ACTIVE (psycopg.pq.TransactionStatus attribute) Adaptation, [1] Boolean dict namedtuple numbers Objects, [1] Strings tuple AdaptContext (class in psycopg.abc) adapters (in module psycopg) (psycopg.abc.AdaptContext property) AdaptersMap (class in psycopg.adapt) add_notice_handler() (psycopg.Connection method)

add_notify_handler() (psycopg.Connection method) args_row() (in module psycopg.rows) as_bytes() (psycopg.sql.Composable method) as_string() (psycopg.sql.Composable method) AsyncConnection (class in psycopg) AsyncCopy (class in psycopg) AsyncCursor (class in psycopg) Asynchronous Notifications asyncio AsyncRowFactory (class in psycopg.rows) AsyncServerCursor (class in psycopg) AsyncTransaction (class in psycopg) AUTO (psycopg.adapt.PyFormat attribute) autocommit (psycopg.Connection attribute)

B

backend_pid (psycopg.ConnectionInfo attribute) BAD (psycopg.pq.ConnStatus attribute) BAD_RESPONSE (psycopg.pq.ExecStatus attribute) BaseRowFactory (class in psycopg.rows) Binary Parameters BINARY (psycopg.adapt.PyFormat attribute) (psycopg.pq.Format attribute) Binary string Binding Client-Side

Boolean Adaptation broken (psycopg.Connection attribute) bytea Adaptation bytearray Adaptation bytes Adaptation

C

cancel() (psycopg.Connection method) (psycopg.pq.PGcancel method) channel (psycopg.Notify attribute) class_row() (in module psycopg.rows) Client-Side Binding Client-side Cursor close() (psycopg.AsyncConnection method) (psycopg.AsyncCursor method) (psycopg.AsyncServerCursor method) (psycopg.Connection method) (psycopg.Cursor method) (psycopg.ServerCursor method) closed (psycopg.Connection attribute) (psycopg.Cursor attribute) Column (class in psycopg) column_name (psycopg.errors.Diagnostic attribute) COLUMN_NAME (psycopg.pq.DiagnosticField attribute) COMMAND_OK (psycopg.pq.ExecStatus attribute) commit() (psycopg.AsyncConnection method) (psycopg.Connection method) Composable (class in psycopg.sql) Composed (class in psycopg.sql) Composite types Data types CompositeInfo (class in psycopg.types.composite) connect() (in module psycopg) (psycopg.AsyncConnection class method) (psycopg.Connection class method) Connection ``with`` Pool

Connection (class in psycopg) connection (psycopg.abc.AdaptContext property) (psycopg.AsyncCursor attribute) (psycopg.AsyncTransaction attribute) (psycopg.Cursor attribute) (psycopg.Transaction attribute) ConnectionInfo (class in psycopg) Conninfo (class in psycopg.pq) conninfo_to_dict() (in module psycopg.conninfo) ConnStatus (class in psycopg.pq) constraint_name (psycopg.errors.Diagnostic attribute) CONSTRAINT_NAME (psycopg.pq.DiagnosticField attribute) context (psycopg.errors.Diagnostic attribute) CONTEXT (psycopg.pq.DiagnosticField attribute) COPY SQL command Copy (class in psycopg) copy() (psycopg.AsyncCursor method) (psycopg.Cursor method) COPY_BOTH (psycopg.pq.ExecStatus attribute) COPY_IN (psycopg.pq.ExecStatus attribute) COPY_OUT (psycopg.pq.ExecStatus attribute) Cursor Client-side Named Server-side Cursor (class in psycopg) cursor() (psycopg.AsyncConnection method) (psycopg.Connection method) cursor_factory (psycopg.AsyncConnection attribute) (psycopg.Connection attribute)

D

Data types Adaptation, [1] Composite types geometry hstore range, [1] DatabaseError DataError datatype_name (psycopg.errors.Diagnostic attribute) DATATYPE_NAME (psycopg.pq.DiagnosticField attribute) dbname (psycopg.ConnectionInfo attribute) Decimal Adaptation DEFAULT (in module psycopg.sql) deferrable (psycopg.Connection attribute)

description (psycopg.Cursor attribute) diag (psycopg.Error attribute) Diagnostic (class in psycopg.errors) DiagnosticField (class in psycopg.pq) dict Adaptation dict_row() (in module psycopg.rows) Differences psycopg2 disconnections display_size (psycopg.Column attribute) dsn (psycopg.ConnectionInfo attribute) dump() (psycopg.abc.Dumper method) (psycopg.adapt.Dumper method) Dumper (class in psycopg.abc) (class in psycopg.adapt)

E

EMPTY_QUERY (psycopg.pq.ExecStatus attribute) Encoding SQL_ASCII encoding (psycopg.ConnectionInfo attribute) environment variable PATH PSYCOPG_IMPL, [1], [2] Error Class error_message (psycopg.ConnectionInfo attribute) error_message() (in module psycopg.pq) Escaping (class in psycopg.pq) Example Usage

Exceptions DB-API PostgreSQL ExecStatus (class in psycopg.pq) execute() (psycopg.AsyncConnection method) (psycopg.AsyncCursor method) (psycopg.AsyncServerCursor method) (psycopg.Connection method) (psycopg.Cursor method) (psycopg.ServerCursor method) executemany() (psycopg.AsyncCursor method) (psycopg.AsyncServerCursor method) (psycopg.Cursor method) (psycopg.ServerCursor method)

F

FAILED (psycopg.pq.PollingStatus attribute) FATAL_ERROR (psycopg.pq.ExecStatus attribute) fetch() (psycopg.types.TypeInfo class method) fetchall() (psycopg.AsyncCursor method) (psycopg.AsyncServerCursor method) (psycopg.Cursor method) (psycopg.ServerCursor method) fetchmany() (psycopg.AsyncCursor method) (psycopg.AsyncServerCursor method) (psycopg.Cursor method) (psycopg.ServerCursor method) fetchone() (psycopg.AsyncCursor method) (psycopg.AsyncServerCursor method) (psycopg.Cursor method) (psycopg.ServerCursor method)

fileno() (psycopg.Connection method) Float Adaptation Format (class in psycopg.pq) format (psycopg.abc.Dumper attribute) (psycopg.abc.Loader attribute) (psycopg.Cursor attribute) format() (psycopg.sql.SQL method) free() (psycopg.pq.PGcancel method)

G

geometry Data types get() (psycopg.types.TypesRegistry method) get_by_subtype() (psycopg.types.TypesRegistry method) get_cancel() (psycopg.pq.PGconn method) get_dumper() (psycopg.adapt.AdaptersMap method)

get_dumper_by_oid() (psycopg.adapt.AdaptersMap method) get_key() (psycopg.abc.Dumper method) (psycopg.adapt.Dumper method) get_loader() (psycopg.adapt.AdaptersMap method) get_oid() (psycopg.types.TypesRegistry method) get_parameters() (psycopg.ConnectionInfo method)

H

host (psycopg.ConnectionInfo attribute) hostaddr (psycopg.ConnectionInfo attribute)

hstore Data types

I

Identifier (class in psycopg.sql) IDLE (psycopg.pq.TransactionStatus attribute) idle in transaction INERROR (psycopg.pq.TransactionStatus attribute) InFailedSqlTransaction info (psycopg.Connection attribute) Integer Adaptation IntegrityError InterfaceError

internal_position (psycopg.errors.Diagnostic attribute) INTERNAL_POSITION (psycopg.pq.DiagnosticField attribute) internal_query (psycopg.errors.Diagnostic attribute) INTERNAL_QUERY (psycopg.pq.DiagnosticField attribute) internal_size (psycopg.Column attribute) InternalError INTRANS (psycopg.pq.TransactionStatus attribute) isempty (psycopg.types.range.Range attribute) isolation_level (psycopg.Connection attribute) IsolationLevel (class in psycopg) itersize (psycopg.ServerCursor attribute)

J

join() (psycopg.sql.Composed method) (psycopg.sql.SQL method)

Json (class in psycopg.types.json) Jsonb (class in psycopg.types.json)

K

kwargs_row() (in module psycopg.rows)

L

libpq LISTEN SQL command Literal (class in psycopg.sql) load() (psycopg.abc.Loader method) (psycopg.adapt.Loader method)

Loader (class in psycopg.abc) (class in psycopg.adapt) lookup() (in module psycopg.errors) lower (psycopg.types.range.Range attribute) lower_inc (psycopg.types.range.Range attribute) lower_inf (psycopg.types.range.Range attribute)

M

make_conninfo() (in module psycopg.conninfo) memoryview Adaptation message_detail (psycopg.errors.Diagnostic attribute) MESSAGE_DETAIL (psycopg.pq.DiagnosticField attribute) message_hint (psycopg.errors.Diagnostic attribute) MESSAGE_HINT (psycopg.pq.DiagnosticField attribute) message_primary (psycopg.errors.Diagnostic attribute) MESSAGE_PRIMARY (psycopg.pq.DiagnosticField attribute) module psycopg psycopg._dns psycopg.abc psycopg.adapt psycopg.conninfo psycopg.errors psycopg.pq psycopg.rows psycopg.sql psycopg.types psycopg_pool

Multirange (class in psycopg.types.multirange) MultirangeInfo (class in psycopg.types.multirange)

N

name (psycopg.Column attribute) (psycopg.ServerCursor attribute) Named Cursor namedtuple Adaptation namedtuple_row() (in module psycopg.rows) News nextset() (psycopg.Cursor method) NO_ATTEMPT (psycopg.pq.Ping attribute)

NO_RESPONSE (psycopg.pq.Ping attribute) NONFATAL_ERROR (psycopg.pq.ExecStatus attribute) Notifications Asynchronous notifies() (psycopg.AsyncConnection method) (psycopg.Connection method) NOTIFY SQL command Notify (class in psycopg) NotSupportedError NULL (in module psycopg.sql)

O

Objects Adaptation, [1] oid (psycopg.abc.Dumper attribute) OK (psycopg.pq.ConnStatus attribute) (psycopg.pq.Ping attribute) (psycopg.pq.PollingStatus attribute)

OperationalError options (psycopg.ConnectionInfo attribute)

P

parameter_status() (psycopg.ConnectionInfo method) Parameters Binary Query password (psycopg.ConnectionInfo attribute) PATH payload (psycopg.Notify attribute) PGcancel (class in psycopg.pq) PGconn (class in psycopg.pq) pgconn (psycopg.Connection attribute) pgconn_ptr (psycopg.pq.PGconn attribute) PGresult (class in psycopg.pq) pgresult (psycopg.Cursor attribute) pgresult_ptr (psycopg.pq.PGresult attribute) pid (psycopg.Notify attribute) Ping (class in psycopg.pq) PIPELINE_ABORTED (psycopg.pq.ExecStatus attribute) PIPELINE_SYNC (psycopg.pq.ExecStatus attribute) Placeholder (class in psycopg.sql) PollingStatus (class in psycopg.pq) Pool Connection port (psycopg.ConnectionInfo attribute) Portal PostGIS Data types precision (psycopg.Column attribute) prepare_threshold (psycopg.Connection attribute) Prepared statements prepared_max (psycopg.Connection attribute)

ProgrammingError psycopg module psycopg._dns module psycopg.abc module psycopg.adapt module psycopg.conninfo module psycopg.errors module psycopg.pq module psycopg.rows module psycopg.sql module psycopg.types module psycopg2 Differences PSYCOPG_IMPL, [1], [2] psycopg_pool module PyFormat (class in psycopg.adapt) Python Enhancement Proposals PEP 0484 python_type (psycopg.types.composite.CompositeInfo attribute)

Q

Query Parameters

quote() (in module psycopg.sql) (psycopg.abc.Dumper method) (psycopg.adapt.Dumper method)

R

range Data types, [1] Range (class in psycopg.types.range) RangeInfo (class in psycopg.types.range) read() (psycopg.AsyncCopy method) (psycopg.Copy method) READ_COMMITTED (psycopg.IsolationLevel attribute) read_only (psycopg.Connection attribute) read_row() (psycopg.AsyncCopy method) (psycopg.Copy method) READ_UNCOMMITTED (psycopg.IsolationLevel attribute) READING (psycopg.pq.PollingStatus attribute) register() (psycopg.types.TypeInfo method) register_composite() (in module psycopg.types.composite) register_dumper() (psycopg.adapt.AdaptersMap method) register_hstore() (in module psycopg.types.hstore) register_loader() (psycopg.adapt.AdaptersMap method) register_multirange() (in module psycopg.types.multirange) register_range() (in module psycopg.types.range) register_shapely() (in module psycopg.types.shapely) REJECT (psycopg.pq.Ping attribute) Release notes

remove_notice_handler() (psycopg.Connection method) remove_notify_handler() (psycopg.Connection method) REPEATABLE_READ (psycopg.IsolationLevel attribute) resolve_hostaddr_async() (in module psycopg._dns) resolve_srv() (in module psycopg._dns) resolve_srv_async() (in module psycopg._dns) RFC RFC 2782 Rollback rollback() (psycopg.AsyncConnection method) (psycopg.Connection method) row factories Row Factory Row Maker row_factory (psycopg.AsyncConnection attribute) (psycopg.Connection attribute) (psycopg.Cursor attribute) rowcount (psycopg.Cursor attribute) RowFactory (class in psycopg.rows) RowMaker (class in psycopg.rows) rownumber (psycopg.Cursor attribute) rows() (psycopg.AsyncCopy method) (psycopg.Copy method)

S

savepoint_name (psycopg.Transaction attribute) scale (psycopg.Column attribute) schema_name (psycopg.errors.Diagnostic attribute) SCHEMA_NAME (psycopg.pq.DiagnosticField attribute) scroll() (psycopg.AsyncCursor method) (psycopg.AsyncServerCursor method) (psycopg.Cursor method) (psycopg.ServerCursor method) scrollable (psycopg.ServerCursor attribute) Security SERIALIZABLE (psycopg.IsolationLevel attribute) Server-side Cursor server_cursor_factory (psycopg.AsyncConnection attribute) (psycopg.Connection attribute) server_version (psycopg.ConnectionInfo attribute) ServerCursor (class in psycopg) set_autocommit() (psycopg.AsyncConnection method) set_deferrable() (psycopg.AsyncConnection method) set_isolation_level() (psycopg.AsyncConnection method) set_json_dumps() (in module psycopg.types.json) set_json_loads() (in module psycopg.types.json) set_read_only() (psycopg.AsyncConnection method) set_types() (psycopg.Copy method) severity (psycopg.errors.Diagnostic attribute) SEVERITY (psycopg.pq.DiagnosticField attribute) severity_nonlocalized (psycopg.errors.Diagnostic attribute)

SEVERITY_NONLOCALIZED (psycopg.pq.DiagnosticField attribute) SINGLE_TUPLE (psycopg.pq.ExecStatus attribute) source_file (psycopg.errors.Diagnostic attribute) SOURCE_FILE (psycopg.pq.DiagnosticField attribute) source_function (psycopg.errors.Diagnostic attribute) SOURCE_FUNCTION (psycopg.pq.DiagnosticField attribute) source_line (psycopg.errors.Diagnostic attribute) SOURCE_LINE (psycopg.pq.DiagnosticField attribute) SQL (class in psycopg.sql) SQL command COPY LISTEN NOTIFY SQL injection SQL_ASCII Encoding sqlstate (psycopg.Error attribute) (psycopg.errors.Diagnostic attribute) SQLSTATE (psycopg.pq.DiagnosticField attribute) statement_position (psycopg.errors.Diagnostic attribute) STATEMENT_POSITION (psycopg.pq.DiagnosticField attribute) status (psycopg.ConnectionInfo attribute) statusmessage (psycopg.Cursor attribute) stream() (psycopg.AsyncCursor method) (psycopg.Cursor method) Strings Adaptation

T

table_name (psycopg.errors.Diagnostic attribute) TABLE_NAME (psycopg.pq.DiagnosticField attribute) TEXT (psycopg.adapt.PyFormat attribute) (psycopg.pq.Format attribute) timezone (psycopg.ConnectionInfo attribute) Transaction (class in psycopg) transaction() (psycopg.AsyncConnection method) (psycopg.Connection method) transaction_status (psycopg.ConnectionInfo attribute) Transactions management

TransactionStatus (class in psycopg.pq) Transformer (class in psycopg.adapt) tuple Adaptation tuple_row() (in module psycopg.rows) TUPLES_OK (psycopg.pq.ExecStatus attribute) type_code (psycopg.Column attribute) TypeInfo (class in psycopg.types) types (psycopg.adapt.AdaptersMap attribute) TypesRegistry (class in psycopg.types)

U

Unicode Adaptation UNKNOWN (psycopg.pq.TransactionStatus attribute) upgrade() (psycopg.abc.Dumper method) (psycopg.adapt.Dumper method)

upper (psycopg.types.range.Range attribute) upper_inc (psycopg.types.range.Range attribute) upper_inf (psycopg.types.range.Range attribute) Usage Example user (psycopg.ConnectionInfo attribute)

V

version() (in module psycopg.pq)

W

Warning with withhold (psycopg.ServerCursor attribute) write() (psycopg.AsyncCopy method) (psycopg.Copy method)

write_row() (psycopg.AsyncCopy method) (psycopg.Copy method) WRITING (psycopg.pq.PollingStatus attribute)