PostgreSQL Data Types
Dremio supports selecting the following PostgreSQL Database types. The following table shows the mappings from PostgreSQL to Dremio data types.
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) |
name | varchar |
numeric | decimal (as of 4.0 |
oid | bigint |
serial | integer |
text | varchar |
time | time |
timestamp | timestamp |
timestamptz | timestamp |
timetz | time |
varchar | varchar |
Was this page helpful?
Glad to hear it! Thank you for your feedback.
Sorry to hear that. Thank you for your feedback.