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
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)
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)
Install
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)
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)
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)
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)
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)
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
with statement
withhold (cursor attribute)
wrapped (psycopg2.sql.Literal attribute)
write() (psycopg2.extensions.lobject method)

X

Xid (class in psycopg2.extensions)
xid() (connection method)