[DB-SIG] PostgresSQL DB-API Driver

[M.-A. Lemburg]

Martin Kew wrote:
> 
> Is there a DB-API driver for PostgresSQL, I know that there is an interface
> bundled with postgressSQL but I dont think this interface conforms to the spec.

mx.ODBC can be made to link against the Postgresql ODBC driver (and
mx.ODBC is a DB API spec compliant interface).

The next release of mx.ODBC will include the following
setup as subpackage...

Put this into Setup...

#### ODBC interface for PostgreSQL 6.5.x ODBC driver
#
# Note: you will have to fix the paths to point to your installation
# directories.
#
        -DPostgreSQL \
        -DDONT_HAVE_SQLDescribeParam \
        -I/usr/local/pgsql/include/iodbc \
        /usr/local/pgsql/lib/libpsqlodbc.so
#
#

...and add this (modulo some editing) to mxODBC.h of that subpackage:

#elif defined(PostgreSQL)
/* PostgreSQL ODBC driver */
# include "iodbc.h"
# include "isql.h"
# include "isqlext.h"
# define MXODBC_INTERFACENAME "PostgreSQL ODBC"

-- 
Marc-Andre Lemburg
______________________________________________________________________
Business:                                      http://www.lemburg.com/
Python Pages:                           http://www.lemburg.com/python/