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
dict
JSON
Lists
namedtuple
None
numbers
Objects
Strings
tuple
Tuple
adapters (in module psycopg2.extensions)
apilevel (in module psycopg2)
ARCHFLAGS
Array
Adaptation
arraysize (cursor attribute)
AsIs (class in psycopg2.extensions)
async (connection attribute)
async_ (connection attribute)
Asynchronous
Connection
Notifications
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)
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)
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)
Commit
Prepared
Transaction
commit() (connection method)
Composite types
Data types
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
Constants
Connection status
Isolation level
Poll status
Transaction status
COPY
SQL command
copy_expert() (cursor method)
copy_from() (cursor method)
copy_to() (cursor method)
Coroutine
Coroutine;
Example
Cursor
Dictionary
Logging
Named
namedtuple
replication
Replication
Server side
Subclassing
cursor (built-in class)
(class in psycopg2.extensions)
(psycopg2.Error 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
DatabaseError
DataError
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)
DATETIME (in module psycopg2)
DATETIMEARRAY (in module psycopg2.extensions)
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)
dict
Adaptation
Dictionary
Cursor
display_size (psycopg2.extensions.Column attribute)
dsn (connection attribute)
DSN (Database Source Name)
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
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)
Float
Adaptation
Float (class in psycopg2.extensions)
FLOAT (in module psycopg2.extensions)
FLOATARRAY (in module psycopg2.extensions)
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)
getconn() (psycopg2.pool.AbstractConnectionPool method)
getquoted() (psycopg2.extensions.AsIs method)
(psycopg2.extensions.Binary method)
(psycopg2.extensions.ISQLQuote method)
(psycopg2.extensions.QuotedString method)
gevent
Greenlet
H
Host
Connection
hstore
Data types
I
IN operator
INET
Data types
Infinite
Date objects
Info
Connection
info (connection attribute)
Install
disable wheel
from PyPI
wheel
Integer
Adaptation
INTEGER (in module psycopg2.extensions)
INTEGERARRAY (in module psycopg2.extensions)
IntegrityError
InterfaceError
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)
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
JSON
Adaptation
Data types
L
Large objects
lastrowid (cursor attribute)
LD_LIBRARY_PATH
libpq_version() (in module psycopg2.extensions)
License
LISTEN
SQL command
Lists
Adaptation
lobject (class in psycopg2.extensions)
lobject() (connection method)
Logging
Client
Cursor
LONGINTEGER (in module psycopg2.extensions)
LONGINTEGERARRAY (in module psycopg2.extensions)
M
MACADDR
Data types
make_dsn() (in module psycopg2.extensions)
memoryview
Adaptation
Message
replication
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)
Named
Cursor
namedtuple
Adaptation
Cursor
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
NotSupportedError
NULL
Adaptation
null_ok (psycopg2.extensions.Column attribute)
NUMBER (in module psycopg2)
O
Objects
Adaptation
Creating new adapters
oid
(psycopg2.extensions.lobject attribute)
OperationalError
P
Parameters
Connection
,
[1]
Query
Server
paramstyle (in module psycopg2)
parse_dsn() (in module psycopg2.extensions)
Password
Connection
PATH
,
[1]
,
[2]
,
[3]
PgBouncer
unclean server
pgcode (psycopg2.Error attribute)
pgconn_ptr (connection attribute)
pgerror (psycopg2.Error attribute)
pgresult_ptr (cursor attribute)
PID
Backend
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
precision (psycopg2.extensions.Column attribute)
Prepare
Transaction
prepare() (psycopg2.extensions.ISQLQuote method)
Prepared
Commit
Rollback
Prerequisites
ProgrammingError
Protocol
Version
protocol_version (connection 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
Read only
read() (psycopg2.extensions.lobject method)
readonly (connection attribute)
Recover
Transaction
register_adapter() (in module psycopg2.extensions)
register_type() (in module psycopg2.extensions)
Release notes
Replication
Cursor
replication
Connection
Cursor
Message
REPLICATION_LOGICAL (in module psycopg2.extras)
REPLICATION_PHYSICAL (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
scale (psycopg2.extensions.Column 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)
setinputsizes() (cursor method)
setoutputsize() (cursor method)
setup.cfg
setup.py
SQL command
COPY
DECLARE
FETCH
LISTEN
MOVE
NOTIFY
SQL injection
SQL_IN (class in psycopg2.extensions)
standard_conforming_string
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_column (psycopg2.extensions.Column attribute)
table_oid (psycopg2.extensions.Column attribute)
tell() (psycopg2.extensions.lobject method)
tests
Thread safety
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_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 casting
type_code (psycopg2.extensions.Column attribute)
tzinfo_factory (cursor attribute)
U
Unicode
Adaptation
UNICODE (in module psycopg2.extensions)
UNICODEARRAY (in module psycopg2.extensions)
unlink() (psycopg2.extensions.lobject method)
Usage
Example
Username
Connection
UUID
Data types
V
Version
Protocol
Server
W
Wait callback
Warning
Wheel
disable
with statement
withhold (cursor attribute)
write() (psycopg2.extensions.lobject method)
X
xid() (connection method)
Quick search