PostgreSQL Data Type Mapping
- 1 Minute to read
- Print
- DarkLight
- PDF
PostgreSQL Data Type Mapping
- 1 Minute to read
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
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?