Index

_ | A | B | C | D | E | F | G | H | I | J | L | M | N | O | P | Q | R | S | T | U | V | W | X

_

_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
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 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)
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)