Home | Trees | Index | Help |
---|
|
A Python driver for PostgreSQL
psycopg is a PostgreSQL database adapter for the Python programming language. This is version 2, a complete rewrite of the original code to provide new-style classes for connection and cursor objects and other sweet candies. Like the original, psycopg 2 was written with the aim of being very small and fast, and stable as a rock.
Homepage: http://initd.org/projects/psycopg2
Submodules | |
---|---|
Exceptions | |
---|---|
DatabaseError |
Error related to the database engine. |
DataError |
Error related to problems with the processed data. |
Error |
Base class for error exceptions. |
IntegrityError |
Error related to database integrity. |
InterfaceError |
Error related to the database interface. |
InternalError |
The database encountered an internal error. |
NotSupportedError |
A not supported datbase API was called. |
OperationalError |
Error related to database operation (disconnect, memory allocation etc). |
ProgrammingError |
Error related to database programming (SQL error, table not found etc). |
Warning |
A database warning. |
Function Summary | |
---|---|
Connections creation | |
extensions.connection |
Create a new database connection. |
Value objects constructors | |
new binary object |
Build an object capable to hold a bynary string value. |
new date |
Build an object holding a date value. |
new date |
Build an object holding a date value from the given ticks value. |
new time |
Build an object holding a time value. |
new time |
Build an object holding a time value from the given ticks value. |
new timestamp |
Build an object holding a timestamp value. |
new timestamp |
Build an object holding a timestamp value from the given ticks value. |
Function Details |
---|
connect(dsn, ...)Create a new database connection. This function supports two different but equivalent sets of arguments. A single data source name or dsn string can be used to specify the connection parameters, as follows: psycopg2.connect("dbname=xxx user=xxx ...") If dsn is not provided it is possible to pass the parameters as keyword arguments; e.g.: psycopg2.connect(database='xxx', user='xxx', ...) The full list of available parameters is:
If the connection_factory keyword argument is not provided this
function always return an instance of the
|
Binary(buffer)Build an object capable to hold a bynary string value.
|
Date(year, month, day)Build an object holding a date value.
|
DateFromTicks(ticks)Build an object holding a date value from the given ticks value. Ticks are the number of seconds since the epoch; see the documentation of the standard Python time module for details).
|
Time(hour, minutes, seconds, tzinfo=None)Build an object holding a time value.
|
TimeFromTicks(ticks)Build an object holding a time value from the given ticks value. Ticks are the number of seconds since the epoch; see the documentation of the standard Python time module for details).
|
Timestamp(year, month, day, hour, minutes, seconds, tzinfo=None)Build an object holding a timestamp value.
|
TimestampFromTicks(ticks)Build an object holding a timestamp value from the given ticks value. Ticks are the number of seconds since the epoch; see the documentation of the standard Python time module for details).
|
Home | Trees | Index | Help |
---|
Generated by Epydoc 2.1 on Sat Jan 14 01:42:35 2006 | http://epydoc.sf.net |