9. Interface Drivers for PostgreSQL

9.1 ODBC Drivers for PostgreSQL

ODBC stands for 'Open DataBase Connectivity' established by Microsoft, is a popular standard for accessing information from various databases from different vendors. Applications written using the ODBC drivers are guaranteed to work with various databases like PostgreSQL, Oracle, Sybase, Informix etc..

• PostODBC is already included in the distribution. See main web site http://www.postgresql.org. It is included on the PostgreSQL CDROM.
• Open source code ODBC project is at http://www.iodbc.org
• http://www.openlinksw.com Open Link Software Corporation is selling ODBC for PostgreSQL and other databases. Open Link also is giving away free ODBC (limited seats) check them out.
• Insight ODBC for PostgreSQL http://www.insightdist.com/psqlodbc This is the official PostODBC site.
• FreeODBC package http://www.ids.net/~bjepson/freeODBC/ This is a free of cost version of ODBC.

9.2 UDBC Drivers for PostgreSQL

UDBC is a static version of ODBC independent of driver managers and DLL support, used to embed database connectivity support directly into applications.

• http://www.openlinksw.com Open Link Software Corporation is selling UDBC for PostgreSQL and other databases. Open Link also is giving away free UDBC (limited seats) check them out.

9.3 JDBC Drivers for PostgreSQL

JDBC stands for 'Java DataBase Connectivity'. Java is a platform independent programming language developed by Sun Microsystems. Java programmers are encouraged to write database applications using the JDBC to facilitate portability across databases like PostgreSQL, Oracle, informix, etc. If you write Java applications you can get JDBC drivers for PostgreSQL from the following sites:

JDBC driver is already included in the PostgreSQL distribution in postgresql-jdbc*.rpm.

• http://www.demon.co.uk/finder/postgres/index.html Sun's Java connectivity to PostgreSQL
• ftp://ftp.ai.mit.edu/people/rst/rst-jdbc.tar.gz
• http://www.openlinksw.com Open Link Software Corporation is selling JDBC for PostgreSQL and other databases. Open Link also is giving away free JDBC (limited seats) check them out.
• JDBC UK site http://www.retep.org.uk/postgres
• JDBC FAQ site http://eagle.eku.edu/tools/jdbc/faq.html

The JDBC home, guide and FAQ are located at -

• JDBC HOME http://splash.javasoft.com/jdbc
• JDBC guide http://www.javasoft.com/products/jdk/1.1/docs/guide/jdbc
• JDBC FAQ http://javanese.yoyoweb.com/JDBC/FAQ.txt

9.4 Java for PostgreSQL

Java programmers can find these for PostgreSQL very useful.

• ftp://ftp.redhat.com/pub/contrib/i386 and see postgresql-jdbc-*.rpm
• http://www.blackdown.org