Package psycopg2 :: Module _psycopg
[show private | hide private]
[frames | no frames]

Module psycopg2._psycopg

psycopg PostgreSQL driver


Classes
connection connection(dsn, ...) -> new connection object
cursor A database cursor.
ISQLQuote Abstract ISQLQuote protocol

Function Summary
new quoted list List(list, enc)

Variable Summary
str __version__ = '2.0b7 (dt ext pq3)'
PyCObject _C_API = <PyCObject object at 0x0076A320>
dict adapters = {(<type 'bool'>, <type 'psycopg2._psycopg.ISQ...
str apilevel = '2.0'
type BINARY = <psycopg2._psycopg.type object at 0x00847A00>
dict binary_types = {}
type BINARYARRAY = <psycopg2._psycopg.type object at 0x00847C...
type BOOLEAN = <psycopg2._psycopg.type object at 0x00847880>
type BOOLEANARRAY = <psycopg2._psycopg.type object at 0x00847...
type DATE = <psycopg2._psycopg.type object at 0x00847960>
type DATEARRAY = <psycopg2._psycopg.type object at 0x00847C20...
type DATETIME = <psycopg2._psycopg.type object at 0x008478C0>
type DATETIMEARRAY = <psycopg2._psycopg.type object at 0x0084...
type DECIMAL = <psycopg2._psycopg.type object at 0x008477A0>
type DECIMALARRAY = <psycopg2._psycopg.type object at 0x00847...
dict encodings = {'UTF8': 'utf_8', 'LATIN-1': 'latin_1', 'SQL...
type FLOAT = <psycopg2._psycopg.type object at 0x00847740>
type FLOATARRAY = <psycopg2._psycopg.type object at 0x00847AE...
type INTEGER = <psycopg2._psycopg.type object at 0x00847700>
type INTEGERARRAY = <psycopg2._psycopg.type object at 0x00847...
type INTERVAL = <psycopg2._psycopg.type object at 0x008479A0>
type INTERVALARRAY = <psycopg2._psycopg.type object at 0x0084...
type LONGINTEGER = <psycopg2._psycopg.type object at 0x008476...
type LONGINTEGERARRAY = <psycopg2._psycopg.type object at 0x0...
type NUMBER = <psycopg2._psycopg.type object at 0x00847680>
str paramstyle = 'pyformat'
type PYDATE = <psycopg2._psycopg.type object at 0x00847DC0>
type PYDATETIME = <psycopg2._psycopg.type object at 0x00847D2...
type PYINTERVAL = <psycopg2._psycopg.type object at 0x00847DE...
type PYTIME = <psycopg2._psycopg.type object at 0x00847D60>
type ROWID = <psycopg2._psycopg.type object at 0x00847A60>
type ROWIDARRAY = <psycopg2._psycopg.type object at 0x00847CC...
type STRING = <psycopg2._psycopg.type object at 0x00847820>
dict string_types = {1028: <psycopg2._psycopg.type object at ...
type STRINGARRAY = <psycopg2._psycopg.type object at 0x00847B...
int threadsafety = 2                                                                     
type TIME = <psycopg2._psycopg.type object at 0x00847900>
type TIMEARRAY = <psycopg2._psycopg.type object at 0x00847BE0...
type UNICODE = <psycopg2._psycopg.type object at 0x008477E0>
type UNICODEARRAY = <psycopg2._psycopg.type object at 0x00847...

Function Details

List(list, enc)

Returns:
new quoted list

Variable Details

__version__

Type:
str
Value:
'2.0b7 (dt ext pq3)'                                                   

_C_API

Type:
PyCObject
Value:
<PyCObject object at 0x0076A320>                                       

adapters

Type:
dict
Value:
{(<type 'datetime.timedelta'>, <type 'psycopg2._psycopg.ISQLQuote'>): \
<built-in function IntervalFromPy>,
 (<type 'datetime.date'>, <type 'psycopg2._psycopg.ISQLQuote'>): <buil\
t-in function DateFromPy>,
 (<type 'datetime.time'>, <type 'psycopg2._psycopg.ISQLQuote'>): <buil\
t-in function TimeFromPy>,
 (<type 'datetime.datetime'>, <type 'psycopg2._psycopg.ISQLQuote'>): <\
built-in function TimestampFromPy>,
...                                                                    

apilevel

Type:
str
Value:
'2.0'                                                                  

BINARY

Type:
type
Value:
<psycopg2._psycopg.type object at 0x00847A00>                          

binary_types

Type:
dict
Value:
{}                                                                     

BINARYARRAY

Type:
type
Value:
<psycopg2._psycopg.type object at 0x00847CA0>                          

BOOLEAN

Type:
type
Value:
<psycopg2._psycopg.type object at 0x00847880>                          

BOOLEANARRAY

Type:
type
Value:
<psycopg2._psycopg.type object at 0x00847BA0>                          

DATE

Type:
type
Value:
<psycopg2._psycopg.type object at 0x00847960>                          

DATEARRAY

Type:
type
Value:
<psycopg2._psycopg.type object at 0x00847C20>                          

DATETIME

Type:
type
Value:
<psycopg2._psycopg.type object at 0x008478C0>                          

DATETIMEARRAY

Type:
type
Value:
<psycopg2._psycopg.type object at 0x00847BC0>                          

DECIMAL

Type:
type
Value:
<psycopg2._psycopg.type object at 0x008477A0>                          

DECIMALARRAY

Type:
type
Value:
<psycopg2._psycopg.type object at 0x00847B20>                          

encodings

Type:
dict
Value:
{'LATIN-1': 'latin_1',
 'LATIN1': 'latin_1',
 'SQL_ASCII': 'ascii',
 'UNICODE': 'utf_8',
 'UTF8': 'utf_8'}                                                      

FLOAT

Type:
type
Value:
<psycopg2._psycopg.type object at 0x00847740>                          

FLOATARRAY

Type:
type
Value:
<psycopg2._psycopg.type object at 0x00847AE0>                          

INTEGER

Type:
type
Value:
<psycopg2._psycopg.type object at 0x00847700>                          

INTEGERARRAY

Type:
type
Value:
<psycopg2._psycopg.type object at 0x00847AC0>                          

INTERVAL

Type:
type
Value:
<psycopg2._psycopg.type object at 0x008479A0>                          

INTERVALARRAY

Type:
type
Value:
<psycopg2._psycopg.type object at 0x00847C60>                          

LONGINTEGER

Type:
type
Value:
<psycopg2._psycopg.type object at 0x008476C0>                          

LONGINTEGERARRAY

Type:
type
Value:
<psycopg2._psycopg.type object at 0x00847AA0>                          

NUMBER

Type:
type
Value:
<psycopg2._psycopg.type object at 0x00847680>                          

paramstyle

Type:
str
Value:
'pyformat'                                                             

PYDATE

Type:
type
Value:
<psycopg2._psycopg.type object at 0x00847DC0>                          

PYDATETIME

Type:
type
Value:
<psycopg2._psycopg.type object at 0x00847D20>                          

PYINTERVAL

Type:
type
Value:
<psycopg2._psycopg.type object at 0x00847DE0>                          

PYTIME

Type:
type
Value:
<psycopg2._psycopg.type object at 0x00847D60>                          

ROWID

Type:
type
Value:
<psycopg2._psycopg.type object at 0x00847A60>                          

ROWIDARRAY

Type:
type
Value:
<psycopg2._psycopg.type object at 0x00847CC0>                          

STRING

Type:
type
Value:
<psycopg2._psycopg.type object at 0x00847820>                          

string_types

Type:
dict
Value:
{16: <psycopg2._psycopg.type object at 0x00847880>,
 17: <psycopg2._psycopg.type object at 0x00847A00>,
 18: <psycopg2._psycopg.type object at 0x00847820>,
 19: <psycopg2._psycopg.type object at 0x00847820>,
 20: <psycopg2._psycopg.type object at 0x008476C0>,
 21: <psycopg2._psycopg.type object at 0x00847700>,
 23: <psycopg2._psycopg.type object at 0x00847700>,
 25: <psycopg2._psycopg.type object at 0x00847820>,
...                                                                    

STRINGARRAY

Type:
type
Value:
<psycopg2._psycopg.type object at 0x00847B60>                          

threadsafety

Type:
int
Value:
2                                                                     

TIME

Type:
type
Value:
<psycopg2._psycopg.type object at 0x00847900>                          

TIMEARRAY

Type:
type
Value:
<psycopg2._psycopg.type object at 0x00847BE0>                          

UNICODE

Type:
type
Value:
<psycopg2._psycopg.type object at 0x008477E0>                          

UNICODEARRAY

Type:
type
Value:
<psycopg2._psycopg.type object at 0x00847B40>