[SQL] Python connection

2004-04-25 Thread Michael Satterwhite
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Consider the following snippet from a Python module: from pyPGSQL import libpq cn = libpq.PQconnectdb("dbname='db', host='xxx'") At this point, I get the error: invalid connection option ", host If I'm reading the document

[SQL] Question re: serial

2004-04-24 Thread Michael Satterwhite
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have a table with a primary key defined as serial unique. When I insert a row into the table, I need to get the value of that row back so that I can use it to link rows in another table to it. How do I do that in Postgresql? I know that I can defi