PostgreSQL Data Types
Dremio supports selecting the following PostgreSQL Database types. The following table shows the mappings from PostgreSQL to Dremio data types.
[info] Note: If a type is not present in the table, it is not currently supported.
PostgreSQL Database 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 | integer |
interval_ds | interval (day to seconds) |
interval_ym | interval (years to months) |
money | double |
name | varchar |
numeric | decimal (as of 4.0 |
oid | bigint |
serial | integer |
text | varchar |
time | time |
timestamp | timestamp |
timestamptz | timestamp |
timetz | time |
varchar | varchar |