• psqlODBC Home
• Download
• Mailing list
• Source code

psqlODBC - PostgreSQL ODBC driver

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

Downloads are available in source and binary formats at thePostgreSQL downloads site

psqlODBC Documentation

The following documents contain various bits of useful information. Please send any additional documentation, or report errors/omissions topgsql-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 topgsql-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 thepgsql-odbc@postgresql.org mailing list.

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 atpostgresql-interfaces/psqlodbc. The source for this website is at thepsqlodbc-www git repository

A backup of the old CVS repository can be foundhere.

psqlODBC History

The source code for this driver was originally adopted from version 0.20 of PostODBC. Theauthors 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 DistributionsSystem overhauled the driver. Their goal was to make the drivercommercially viable. In keeping with the spirit with whichthe original source was acquired, Insight published their work at theirwebsite. Some time later and after some discussion with membersof the PostgreSQL organization, psqlODBC was adapted as the part of thePostgreSQL 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 thePostgreSQL 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.