The following table lists the data types supported by the driver and describes how they are mapped to JDBC data types.
Note: See "getTypeInfo()" for getTypeInfo() results for Amazon Redshift databases supported by the driver.
Table 1. Amazon Redshift Data Types
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
Timestamp TIMESTAMP
1 You can determine how these columns are described by setting the VarcharClobThreshold connection property.