Navigation :

Psycopg - PostgreSQL database adapter for Python - Psycopg 2.7.3 documentation > Index - Psycopg 2.7.3 documentation

Index - Psycopg 2.7.3 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)

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)