Greenplum Data Type | JDBC Data Type |
Bigint | BIGINT |
Bigserial | BIGINT |
Bit | BIT or BINARY 1 |
Bit varying | VARBINARY |
Boolean | BOOLEAN |
Bytea | LONGVARBINARY |
Character | CHAR |
Character varying | VARCHAR or LONGVARCHAR 2 |
Date | DATE |
Double precision | DOUBLE |
Integer | INTEGER |
Numeric | NUMERIC |
Real | REAL |
Serial | INTEGER |
Smallint | SMALLINT |
Text | LONGVARCHAR |
Time | TIMESTAMP |
Time with time zone | TIMESTAMP |
Timestamp | TIMESTAMP |
Timestamp with time zone | TIMESTAMP |