Bob Jarman wrote:
I'm using PyGreSQL: http://www.druid.net/pygresql/
You simply "import pgdb" and get a Python DB-API 2.0-
compliant interface. Here's a short excerpt from one
of my Python programs (simplified for brevity):

import sys
import pgdb

try:
db = pgdb.connect(host = "foo.bar", database = "baz",
user = "chuck", password = "xxxxxxxx")
except pgdb.Error, detail:
print "Cannot open connection to database!"
print detail
sys.exit (1)

try:
cursor = db.cursor()
except pgdb.Error, detail:
print "Cannot acquire cursor for database!"
print detail
sys.exit (1)

try:
cursor.execute ("SELECT * FROM moonlight")
result = cursor.fetchall()
except pgdb.DatabaseError, detail:
print "SQL query failed!"
print detail
sys.exit (1)

db.close()

The full Python DB-API 2.0 documentation can be found in
PEP 249: http://www.python.org/peps/pep-0249.html

Best regards
Oliver

--
Oliver Fromme, secnetix GmbH & Co KG, Oettingenstr. 2, 80538 München
Any opinions expressed in this message may be personal to the author
and may not necessarily reflect the opinions of secnetix in any way.

Python is executable pseudocode. Perl is executable line noise.

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match