On Sep 28, 1:07 pm, Steve Holden <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] wrote: > > On Sep 28, 9:57 am, "Sugrue, Sean" <[EMAIL PROTECTED]> wrote: > >> I'm trying to make an odbc connection to postgresql which is on a server > >> using python. > >> Does anyone have a code snippet to make a basic connection with a select > >> query? > > >> Sean > > > Sean, > > > This appears to be what you're looking for: > > >http://www.devx.com/opensource/Article/29071 > > > See also Python Database spec and module page: > > >http://www.python.org/topics/database/ > > Mike: > > This doesn't address the ODBC part of the inquiry. I was actually going > to respond saying I wasn't aware of an ODBC driver for PostgreSQL > (though I'd be surprised if there wasn't one). > > Using the psycopg2 module, which is my preferred PostgreSQL interface > module, it's easy to answer: > > >>> curs = conn.cursor() > >>> import psycopg2 as db > >>> conn = db.connect(database="pycon", user="username", > password="password", host="localhost", port=5432) > >>> curs = conn.cursor() > >>> curs.execute("SELECT orgid, orgname FROM organization") > >>> from pprint import pprint # just for neatness > >>> pprint(curs.fetchall()) > [(1, 'AB Strakt'), > (79, 'DevIS'), > ... > (113, 'Test Organization'), > (19, 'Holden Web LLC')] > >>> > > regards > Steve > -- > Steve Holden +1 571 484 6266 +1 800 494 3119 > Holden Web LLC/Ltd http://www.holdenweb.com > Skype: holdenweb http://del.icio.us/steve.holden > > Sorry, the dog ate my .sigline
Whoops! I almost posted some code using the adodb or the odbc module, which is what I would have probably used, but I figured I'd take a look and see if there was a postgres module available. I'm not seeing any basic differences between your code and the code I linked to though...except that if I ran your first line of code, I would get an exception as "conn" hasn't been defined yet. Whatever. I apologize for being misleading(?) Mike -- http://mail.python.org/mailman/listinfo/python-list
