Download
About
Binary JAR file downloads of the JDBC driver are available here. Because Java is platform neutral it is a simple process of just downloading the appropriate JAR file and dropping it into your classpath. For this reason the focus here is on providing pre-built versions. If you are interested in compiling from source please see the cvs instructions.
Download Current Version
This JAR contains the current version of the driver. It supports all current versions of PostgreSQL, requires JDK 1.4 or newer and supports JDBC 3. Also contains support for SSL and javax.sql. For nominal JDBC 4 support see below in the version table.
PostgreSQL JDBC Driver, Version 8.2-506 JDBC 3
A number of extras and wrappers are available as well, for example a Statement Caching Wrapper and support for the COPY command. Download them from the Extras page.
Other Versions
Many other versions of this driver are available. This includes development versions, compatibility with older JDKs, the source and previous versions of the driver.
To determine which version of the JDBC driver to download you need to determine what server version you will be running against. In general it is best to pick a matching server and driver release, but there are some exceptions. Newer driver releases will get additional features and bug fixes that you may need. Much care is taken to make newer driver releases work against older servers, so if you are having a problem and suspect it is the driver's fault, don't hesitate to try out the latest release on an older server. The current development driver is known to work with all server versions back to, and including, 7.2.
To determine which JDBC version of the driver you want you need to look at the JDK version you are running.
- JDK 1.1 - JDBC 1. Note that with the 8.0 release JDBC 1 support has been removed, so look to update your JDK when you update your server.
- JDK 1.2, 1.3 - JDBC 2.
- JDK 1.3 + J2EE - JDBC 2 EE. This contains additional support for javax.sql classes.
- JDK 1.4, 1.5 - JDBC 3. This contains support for SSL and javax.sql, but does not require J2EE as it has been added to the J2SE release.
- JDK 1.6 - JDBC4. Support for JDBC4 methods is limited. The driver builds, but the majority of new methods are stubbed out.
Complete Version Table
| Version | JDBC 1 | JDBC 2 | JDBC 2 EE | JDBC 3 | JDBC 4 | Source |
|---|---|---|---|---|---|---|
| 8.3dev Build 601 | 8.3dev-601 JDBC 2 | 8.3dev-601 JDBC 2EE | 8.3dev-601 JDBC 3 | 8.3dev-601 JDBC 4 | 8.3dev-601 JDBC Source | |
| 8.2 Build 506 | 8.2-506 JDBC 2 | 8.2-506 JDBC 2EE | 8.2-506 JDBC 3 | 8.2-506 JDBC 4 | 8.2-506 JDBC Source | |
| 8.1 Build 410 | 8.1-410 JDBC 2 | 8.1-410 JDBC 2EE | 8.1-410 JDBC 3 | 8.1-410 JDBC Source | ||
| 8.0 Build 320 | 8.0-320 JDBC 2 | 8.0-320 JDBC 2EE | 8.0-320 JDBC 3 | 8.0-320 JDBC Source | ||
| 7.4 Build 216 | pg74.216.jdbc1.jar | pg74.216.jdbc2.jar | pg74.216.jdbc2ee.jar | pg74.216.jdbc3.jar | ||
| 7.3 Build 113 | pg73jdbc1.jar | pg73jdbc2.jar | pg73jdbc2ee.jar | pg73jdbc3.jar | ||
| 7.2 | pg72jdbc1.jar | pg72jdbc2.jar | ||||
| 7.1 | jdbc7.1-1.1.jar | jdbc7.1-1.2.jar | ||||
| 7.0 | jdbc7.0-1.1.jar | jdbc7.0-1.2.jar | ||||
| 6.5.2 | jdbc6.5-1.1.jar | jdbc6.5-1.2.jar | ||||
| 6.4 | jdbc6.4-1.1.jar | |||||
| 6.3 | jdbc6.3-1.1.jar | |||||
| 6.2.1 | jdbc6.2.1.tgz | |||||
| 0.4 | JavaPostgres95-0.4.tar.gz | |||||
| 0.3 | JavaPostgres95-0.3.tar.gz | |||||
| 0.2 | JavaPostgres95-0.2.tar.gz |