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

Table 1. Greenplum Data Types
Greenplum 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
CIDR VARCHAR
Circle VARCHAR
Citext3, 4 LONGVARCHAR
Date DATE
DATERANGE 5 VARCHAR
Double precision DOUBLE
INET VARCHAR
INT4RANGE6 VARCHAR
INT8RANGE7 VARCHAR
Interval VARCHAR
Integer INTEGER
Json 8 VARCHAR
Line9 VARCHAR
LSEG VARCHAR
MACADDR VARCHAR
Money VARCHAR
Numeric NUMERIC
NUMRANGE10 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
TSRANGE11 VARCHAR
TSTZRANGE12 VARCHAR
TXID_SNAPSHOT13 VARCHAR
UUID14 VARCHAR
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 Data types 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 Greenplum versions 5.3 and higher.
5 Supported for Greenplum versions 6.0 and higher.
6 Supported for Greenplum versions 6.0 and higher.
7 Supported for Greenplum versions 6.0 and higher.
8 Supported for Greenplum versions 5.0 and higher.
9 Supported for Greenplum versions 6.0 and higher.
10 Supported for Greenplum versions 6.0 and higher.
11 Supported for Greenplum versions 6.0 and higher.
12 Supported for Greenplum versions 6.0 and higher.
13 Supported for Greenplum versions 5.0 and higher.
14 Supported for Greenplum versions 5.0 and higher.