Psycopg is a PostgreSQL database adapter for the Python programming language.
Its main advantages are that it supports the full Python DBAPI 2.0 and it is
thread safe at level 2. It was designed for heavily multi-threaded applications
that create and destroy lots of cursors and make a conspicuous number of
concurrent INSERTs or UPDATEs. The psycopg distribution includes ZPsycopgDA, a
Zope Database Adapter.
Psycopg 2 is an almost complete rewrite of the psycopg 1.1.x branch. Psycopg 2
features complete libpq v3 protocol COPY TO/COPY FROM and full object adaptation
for all basic Python 2.3 ...