On this page

    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