elephant

PostgreSQL JDBC Driver

An Open source JDBC driver written in Pure Java (Type 4), which communicates using the PostgreSQL native network protocol

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

pgJDBC has released v42.7.1 on December 06, 2023. This release primarily fixes 2 regressions SET followed by SHOW in one statement returns wrong result and Server default DateStyle is being overwritten. Notably improved blob performance as well as a number of small changes See notes below for details.

  • 42.7.1 · 06 December 2023 · Notes
  • 42.7.0 · 20 November 2023 · Notes
  • 42.6.0 · 17 March 2023 · Notes
  • 42.5.4 · 16 February 2023 · Notes
  • 42.4.3 · 23 October 2022 · Notes
  • 42.3.8 · 23 October 2022 · Notes
  • 42.2.27 · 23 October 2022 · Notes
feature

pgJDBC allows Java programs to connect to a PostgreSQL database using standard, database independent Java code.

feature

pgJDBC provides a reasonably complete implementation of the JDBC specification in addition to some PostgreSQL specific extensions.

feature

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 ?

support

Support Us

PostgreSQL is free.
Please support our work by making a donation.