The following table lists the data types supported by the driver and describes how they are mapped to JDBC data types. See "getTypeInfo()" for getTypeInfo() results of data types supported by the driver.

Table 1. Amazon Redshift Data Types
Redshift Data Type JDBC Data Type
Bigint BIGINT
Boolean BOOLEAN
Character CHAR
Character varying 1 VARCHAR
Date DATE
Double precision DOUBLE
Integer INTEGER
Numeric NUMERIC
Real REAL
Smallint SMALLINT
Text LONGVARCHAR
Time TIMESTAMP
Time with time zone TIMESTAMP
Timestamp TIMESTAMP
Timestamp with time zone TIMESTAMP
1 You can determine how these columns are described by setting the VarcharClobThreshold connection property.