Edit this page on GitHub

Data types

Storing Binary Data PostgreSQL® provides two distinct ways to store binary data. Binary data can be stored in a table using the data type BYTEA or by using the Large Object feature …
Arrays PostgreSQL® provides robust support for array data types as column types, function arguments and criteria in where clauses. There are several ways to create …
Geometric Data Types PostgreSQL® has a set of data types that can store geometric features into a table. These include single points, lines, and polygons. We support these types in …
Large Objects Large objects are supported in the standard JDBC specification. However, that interface is limited, and the API provided by PostgreSQL® allows for random access …
Timestamp Infinity The driver uses the following values to represent negative and positive infinity: type Negative infinity Positive infinity LocalDateTime LocalDateTime.MIN …
Using Java 8 Date and Time classes The PostgreSQL® JDBC driver implements native support for the Java 8 Date and Time API (JSR-310) using JDBC 4.2. Table 5.1. Supported Java 8 Date and Time …