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