PostgreSQL Datatype Mapping
  • 1 Minute to read
  • Dark
    Light
  • PDF

PostgreSQL Datatype Mapping

  • Dark
    Light
  • PDF

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 Type Rivery Type
INTERVAL STRING
DOUBLE_PRECISION FLOAT
FLOAT FLOAT
CHAR STRING
DATE DATE
VARCHAR STRING
TIMESTAMP TIMESTAMP
ENUM STRING
BOOLEAN BOOLEAN
ARRAY STRING
BYTEA STRING
BIT STRING
REAL FLOAT
BIGINT STRING
SMALLINT INTEGER
NUMERIC FLOAT
INTEGER INTEGER
CIDR STRING
DropEnumType STRING
INET STRING
MACADDR STRING
OID STRING
TSVECTOR STRING
UUID STRING
DATERANGE INTEGER
INT4RANGE INTEGER
INT8RANGE INTEGER
JSON STRING
JSONB STRING
NUMRANGE FLOAT
TSRANGE FLOAT
HSTORE STRING

Was this article helpful?