Postgres+Python+Win32 ?

Jeff Koftinoff jeffk at jdkoftinoff.com
Thu Mar 2 02:22:51 CET 2000


On Wed, 1 Mar 2000, Timothy Grant wrote:

> Jeff Koftinoff wrote:
> > 
> > Hi.
> > 
> > I have a linux box running postgresql and python, and am able to access the
> > database remotely from another linux box. Now I want to be able to access the
> > remote postgresql database from a win32 box running python. I found someplace
> > the postgresql client DLL library from win32, but has anyone made a pgsql or
> > whatever for win32?
> 
> Having just been through this, I believe that the easiest solution would
> be to use ODBC. You can download a PostgreSQL ODBC driver from the
> PostgresSQL ftp site, and then use either the ODBC module that ships
> with the Win32 extensions to Python, or download the excellent mxODBC
> and use it.
> 
> I have successfully been able to code with mxODBC/Tkinter and had the
> code developed on my Linux box run pretty much immediately on a Win box.
>

Thanks for the info! But what is the best way to use odbc with postgresql
under linux with python (because of course I prefer using linux, i just
need portability)...

best regards

jeff

 --
Jeff Koftinoff <jeffk at jdkoftinoff.com>
http://www.jdkoftinoff.com/





More information about the Python-list mailing list