PostgreSQL data type mapping
The system matches PostgreSQL data types to Data Integration data types while extracting your data. If a data type is not supported, it is mapped as a String type.
The following table shows the mapping of PostgreSQL data types to Data Integration-compatible types:
| PostgreSQL Type | Data Integration 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 |
