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 pgsql-odbc@postgresql.org
- 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 pgsql-odbc@postgresql.org
- 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
psqlODBC Development
Previously psqlODBC was developed and supported through the pgsql-odbc@postgresql.org mailing list.
However we have moved the project to GitHub psqlODBC please file issues hereWe 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/):
Copyright 1992-2004 by the Massachusetts Institute of Technology. All rights reserved.
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.