RE: OCBC connection

2007-09-28 Thread Sugrue, Sean
y the code that was sent. Thanks Sean -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Holden Sent: Friday, September 28, 2007 4:04 PM To: python-list@python.org Subject: Re: OCBC connection [EMAIL PROTECTED] wrote: [...] >> >>

Re: OCBC connection

2007-09-28 Thread Steve Holden
[EMAIL PROTECTED] wrote: [...] >> >> >>> 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 organ

Re: OCBC connection

2007-09-28 Thread kyosohma
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 ba

Re: OCBC connection

2007-09-28 Thread M.-A. Lemburg
On 2007-09-28 20:07, Steve Holden 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 s

Re: OCBC connection

2007-09-28 Thread Steve Holden
[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

Re: OCBC connection

2007-09-28 Thread kyosohma
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: