On this page

    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 TypeDremio Type
    bigserialbigint
    bitboolean
    boolboolean
    bpcharvarchar
    byteavarbinary
    charvarchar
    datedate
    double precisiondouble
    float4float
    float8double
    int2integer
    int4integer
    int8integer
    interval_dsinterval (day to seconds)
    interval_yminterval (years to months)
    namevarchar
    numericdecimal (as of 4.0
    oidbigint
    serialinteger
    textvarchar
    timetime
    timestamptimestamp
    timestamptztimestamp
    timetztime
    varcharvarchar