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 |