Why pgJDBC?
The PostgreSQL JDBC Driver allows Java programs to connect to a PostgreSQL database using standard, database independent Java code. pgJDBC is an open source JDBC driver written in Pure Java (Type 4), and communicates in the PostgreSQL native network protocol. Because of this, the driver is platform independent; once compiled, the driver can be used on any system.
Latest Releases
Current release is 42.7.7 This is a security release to address CVE-2025-49146
- 42.7.7 · 11 June 2025 · Notes
- 42.7.6 · 28 May 2025 · Notes
- 42.7.5 · 14 January 2025 · Notes
- 42.7.4 · 20 August 2024 · Notes
- 42.7.3 · 14 March 2024 · Notes
- 42.6.2 · 13 March 2024 · Notes
- 42.5.6 · 13 March 2024 · Notes
- 42.4.5 · 13 March 2024 · Notes
- 42.3.10 · 13 March 2024 · Notes
- 42.2.29 · 13 March 2024 · Notes
pgJDBC allows Java programs to connect to a PostgreSQL database using standard, database independent Java code.
pgJDBC provides a reasonably complete implementation of the JDBC specification in addition to some PostgreSQL specific extensions.
The current development driver supports eleven server versions and three java environments.
Processing a simple query
This example will issue a simple query and print out the first column of each row using a Statement.
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery("SELECT * FROM mytable WHERE columnfoo = 500");
while (rs.next()) {
System.out.print("Column 1 returned ");
System.out.println(rs.getString(1));
}
rs.close();
st.close();
Report a bug or Contribute ?
Report a security issue,
here.
See something that's wrong or unclear?
submit a PR.
Support Us
PostgreSQL is free.
Please support our work by making a
donation.