The following table lists the data types supported by the PostgreSQL driver and describes how they are mapped to JDBC data types.

Table 1. PostgreSQL Data Types
PostgreSQL Data Type JDBC Data Type
Bigint BIGINT
Bigserial BIGINT
Bit BIT or BINARY 1
Bit varying VARBINARY
Boolean BOOLEAN
Box VARCHAR
Bytea LONGVARBINARY
Character CHAR
Character varying VARCHAR or LONGVARCHAR 2
Citext3, 4 LONGVARCHAR
CIDR VARCHAR
Circle VARCHAR
Date DATE
DATERANGE 5 VARCHAR
Double precision DOUBLE
INET VARCHAR
INT4RANGE6 VARCHAR
INT8RANGE7 VARCHAR
Interval VARCHAR
Integer INTEGER
Json8 VARCHAR
Jsonb 9 VARCHAR
Line 10 VARCHAR
LSEG VARCHAR
MACADDR VARCHAR
Money VARCHAR
Numeric NUMERIC
NUMRANGE11 VARCHAR
Path VARCHAR
Point VARCHAR
Polygon VARCHAR
Real REAL
Serial INTEGER
Smallint SMALLINT
Text LONGVARCHAR
Time TIMESTAMP
Time with time zone TIMESTAMP
Timestamp TIMESTAMP
Timestamp with time zone TIMESTAMP
TSRANGE12 VARCHAR
TSTZRANGE13 VARCHAR
TXID_SNAPSHOT 14 VARCHAR
UUID 15 VARCHAR
XML 16 SQLXML
1 Bit maps to -7 (BIT) when the length for the bit is 1. If the length is greater than 1, the driver maps the column to BINARY.
2 You may determine how these columns are described by setting the VarcharClobThreshold connection property.
3 The Citext data type behaves the same as the Text data type, except that it is case-insensitive. The select operations performed on Citext columns return case-insensitive results.
4 Supported for PostgreSQL versions 9.4 and higher.
5 Supported for PostgreSQL versions 9.2 and higher.
6 Supported for PostgreSQL versions 9.2 and higher.
7 Supported for PostgreSQL versions 9.2 and higher.
8 Supported for PostgreSQL versions 9.2 and higher.
9 Supported for PostgreSQL versions 9.4 and higher.
10 Supported for PostgreSQL versions 7.1 and higher.
11 Supported for PostgreSQL versions 9.2 and higher.
12 Supported for PostgreSQL versions 9.2 and higher.
13 Supported for PostgreSQL versions 9.2 and higher.
14 Supported for PostgreSQL versions 8.3 and higher.
15 Supported for PostgreSQL versions 8.3 and higher.
16 Supported for PostgreSQL versions 8.3 and higher.