psqlODBC - PostgreSQL ODBC driver

psqlODBC is the official PostgreSQL ODBC Driver. It is released under the Library General Public Licence , or LGPL.

Downloads are available in source and binary formats at the PostgreSQL downloads site

psqlODBC Documentation

The following documents contain various bits of useful information. Please send any additional documentation, or report errors/omissions to [email protected]

Notes on the various configuration settings.

Compiling psqlODBC on Win32 systems.

Compiling psqlODBC on Unix systems.

Frequently Asked Questions (FAQ).

Release notes.

psqlODBC HOWTOs

The following HOWTOs have been contributed by various people. If you wish to add to the collection, please send your contribution to [email protected]

Example based Mini-Howto on Accessing PostgreSQL from C#

Example based Mini-Howto on Accessing PostgreSQL from Ch

Using large objects in Microsoft Access (notes from the original psqlODBC docs)

Example based Mini-Howto on using Microsoft Access VBA with PostgreSQL

Example based Mini-Howto on Accessing PostgreSQL from Visual Basic

Example based Mini-Howto on Pgsql Large Objects Interface and Visual Basic

PostgreSQL and Business Objects

Previously psqlODBC was developed and supported through the [email protected] mailing list.

However we have moved the project to GitHub psqlODBC please file issues here

We will continue to monitor the pgsql-odbc mailing list however it's preferable to use GitHub.

You can browse the source code at the psqlODBC git repository at postgresql-interfaces/psqlodbc . The source for this website is at the psqlodbc-www git repository

A backup of the old CVS repository can be found here .

psqlODBC History

The source code for this driver was originally adopted from version 0.20 of PostODBC. The authors at that time were Christian Czezatke and Dan McGuirk. Later it was maintained by Julie Ann Case.

As part of a commercial research project, the developers at Insight Distributions System overhauled the driver. Their goal was to make the driver commercially viable. In keeping with the spirit with which the original source was acquired, Insight published their work at their website. Some time later and after some discussion with members of the PostgreSQL organization, psqlODBC was adapted as the part of the PostgreSQL source distribution. The driver continued to be maintained by Byron Nikolaidis, the developer at Insight who overhauled the driver for some time.

The driver is currently maintained by a number of contributors to the PostgreSQL project.

Acknowledgements

OpenSSL

This product includes software developed by the OpenSSL Project for use in the OpenSSL Toolkit ( http://www.openssl.org/ ).

MIT Kerberos

This product includes Kerberos software developed by the Massachusetts Institute of Technology ( http://web.mit.edu/kerberos/ ):

THIS SOFTWARE IS PROVIDED "AS IS", AND M.I.T. MAKES NO REPRESENTATIONS OR WARRANTIES, EXPRESS OR IMPLIED. By way of example, but not limitation, M.I.T. MAKES NO REPRESENTATIONS OR WARRANTIES OF MERCHANTABILITY OR FITNESS FOR ANY PARTICULAR PURPOSE OR THAT THE USE OF THE LICENSED SOFTWARE OR DOCUMENTATION WILL NOT INFRINGE ANY THIRD PARTY PATENTS, COPYRIGHTS, TRADEMARKS OR OTHER RIGHTS.