jdbc.postgresql.org
Open in
urlscan Pro
72.32.157.228
Public Scan
Submitted URL: http://jdbc.postgresql.org/
Effective URL: https://jdbc.postgresql.org/
Submission: On November 28 via manual from PL — Scanned from PL
Effective URL: https://jdbc.postgresql.org/
Submission: On November 28 via manual from PL — Scanned from PL
Form analysis 1 forms found in the DOM
<form id="search" class="searchBox" role="search">
<input class="searchInput" type="search" name="" placeholder="Search" id="search-input" autocomplete="off">
<button class="searchButton" for="search-input">
<svg fill="#ffffff" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64" width="24px" height="24px">
<path
d="M 24 2.8886719 C 12.365714 2.8886719 2.8886719 12.365723 2.8886719 24 C 2.8886719 35.634277 12.365714 45.111328 24 45.111328 C 29.036552 45.111328 33.664698 43.331333 37.298828 40.373047 L 52.130859 58.953125 C 52.130859 58.953125 55.379484 59.435984 57.396484 57.333984 C 59.427484 55.215984 58.951172 52.134766 58.951172 52.134766 L 40.373047 37.298828 C 43.331332 33.664697 45.111328 29.036548 45.111328 24 C 45.111328 12.365723 35.634286 2.8886719 24 2.8886719 z M 24 7.1113281 C 33.352549 7.1113281 40.888672 14.647457 40.888672 24 C 40.888672 33.352543 33.352549 40.888672 24 40.888672 C 14.647451 40.888672 7.1113281 33.352543 7.1113281 24 C 7.1113281 14.647457 14.647451 7.1113281 24 7.1113281 z">
</path>
</svg>
</button>
</form>Text Content
Download Documentation Community Development Changelogs Security
Read More »
POSTGRESQL JDBC DRIVER
AN OPEN SOURCE JDBC DRIVER WRITTEN IN PURE JAVA (TYPE 4), WHICH COMMUNICATES
USING THE POSTGRESQL NATIVE NETWORK PROTOCOL
Download Go To Docs
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.0 on November 20, 2023. This release is mostly a
maintenance release but the change in allowing SET statemnts in PR #2973 is a
breaking change which necessitates the major version change.
* 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
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.
* pgJDBC
* Public API
* About PostgreSQL
* Community
* Github
* Slack
* Twitter
* Mailing List
* More
* FAQ
* Privacy
* License
Copyright © 1996-2023 The PostgreSQL Global Development Group
* Download
* Documentation
* Community
* Development
* Changelogs
* Security
* Getting Started
* Initializing the Driver
* Using SSL
* Issuing a Query and Processing the Result
* Calling Stored Functions and Procedures
* Storing Binary Data
* JDBC escapes
* PostgreSQL™ Extensions to the JDBC API
* Using the Driver in a Multithreaded or a Servlet Environment
* Connection Pools and Data Sources
* Logging using java.util.logging
* Further Reading
Main Menu Docs Menu