PostgreSQL Data Type Mapping
  • 1 Minute to read
  • Dark
    Light
  • PDF

PostgreSQL Data Type Mapping

  • Dark
    Light
  • PDF

Article summary

We match PostgreSQL data types to Rivery data types while extracting your data. If a data type is not supported, we will map it as a String type.

The following table shows the mapping of PostgreSQL data types to Rivery-compatible types:

PostgreSQL TypeRivery Type
INTERVALSTRING
DOUBLE_PRECISIONFLOAT
FLOATFLOAT
CHARSTRING
DATEDATE
VARCHARSTRING
TIMESTAMPTIMESTAMP
ENUMSTRING
BOOLEANBOOLEAN
ARRAYSTRING
BYTEASTRING
BITSTRING
REALFLOAT
BIGINTSTRING
SMALLINTINTEGER
NUMERICFLOAT
INTEGERINTEGER
CIDRSTRING
DropEnumTypeSTRING
INETSTRING
MACADDRSTRING
OIDSTRING
TSVECTORSTRING
UUIDSTRING
DATERANGEINTEGER
INT4RANGEINTEGER
INT8RANGEINTEGER
JSONSTRING
JSONBSTRING
NUMRANGEFLOAT
TSRANGEFLOAT
HSTORESTRING

Was this article helpful?