Skip to main content

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 TypeDremio Type
BIGSERIALBIGINT
BITBOOLEAN
BOOLBOOLEAN
BPCHARVARCHAR
BYTEAVARBINARY
CHARVARCHAR
DATEDATE
DOUBLE PRECISIONDOUBLE
FLOAT4FLOAT
FLOAT8DOUBLE
INT2INTEGER
INT4INTEGER
INT8BIGINT
INTERVAL_DSINTERVAL (day to seconds)
INTERVAL_YMINTERVAL (years to months)
MONEYDOUBLE
NAMEVARCHAR
NUMERICDECIMAL
OIDBIGINT
SERIALINTEGER
TEXTVARCHAR
TIMETIME
TIMESTAMPTIMESTAMP
TIMESTAMPTZTIMESTAMP
TIMETZTIME
VARCHARVARCHAR