PostgreSQL Data Types
Dremio supports PostgreSQL data types, as shown in the following table which provides the mappings from PostgreSQL to Dremio data types. If there are additional PostgreSQL types not listed in the table, then those types are not supported in Dremio.
| PostgreSQL Data Type | Dremio Type |
|---|---|
| BIGSERIAL | BIGINT |
| BIT | BOOLEAN |
| BOOL | BOOLEAN |
| BPCHAR | VARCHAR |
| BYTEA | VARBINARY |
| CHAR | VARCHAR |
| DATE | DATE |
| DOUBLE PRECISION | DOUBLE |
| FLOAT4 | FLOAT |
| FLOAT8 | DOUBLE |
| INT2 | INTEGER |
| INT4 | INTEGER |
| INT8 | BIGINT |
| INTERVAL_DS | INTERVAL (day to seconds) |
| INTERVAL_YM | INTERVAL (years to months) |
| MONEY | DOUBLE |
| NAME | VARCHAR |
| NUMERIC | DECIMAL |
| OID | BIGINT |
| SERIAL | INTEGER |
| TEXT | VARCHAR |
| TIME | TIME |
| TIMESTAMP | TIMESTAMP |
| TIMESTAMPTZ | TIMESTAMP |
| TIMETZ | TIME |
| VARCHAR | VARCHAR |