Datatype Matrices
PostgreSQL
This page explains how data types are mapped from a source PostgreSQL database to the target databases. Please visit the PostgreSQL Data Types Documentation to get a primer on the various PostgreSQL datatypes.
Mapping
The following table explains how the PostgreSQL datatypes are mapped to the target databases.| Postgres Datatype | Firebolt Datatype | Snowflake Datatype |
|---|---|---|
| Numbers | ||
SMALLINT | INTEGER | SMALLINT |
INT | INTEGER | INT |
BIGINT | BIGINT | BIGINT |
NUMERIC | NUMERIC | NUMBER |
FLOAT | REAL | FLOAT |
REAL | REAL | FLOAT |
DOUBLE PRECISION | DOUBLE | FLOAT |
SMALLSERIAL | INTEGER | SMALLINT |
SERIAL | INTEGER | INT |
BIGSERIAL | BIGINT | BIGINT |
MONEY | NUMERIC | NUMBER |
BOOLEAN | BOOLEAN | BOOLEAN |
OBJECT IDENTIFIER TYPES | INTEGER | INT |
| Times | ||
TIMESTAMP | TIMESTAMP | TIMESTAMP_NTZ |
TIMESTAMP WITH TIME ZONE | TIMESTAMPTZ | TIMESTAMP_TZ |
DATE | DATE | DATE |
TIME | TEXT | TIME |
TIME WITH TIME ZONE | TEXT | TIME |
INTERVAL | TEXT | VARCHAR |
| Strings | ||
CHARACTER | TEXT | VARCHAR |
CHARACTER VARYING | TEXT | VARCHAR |
TEXT | TEXT | VARCHAR |
UUID | TEXT | VARCHAR |
XML | TEXT | VARCHAR |
JSON | TEXT | VARIANT |
JSONB | TEXT | VARIANT |
ENUM | TEXT | VARCHAR |
GEOMETRIC TYPES | TEXT | VARCHAR |
NETWORK ADDRESS TYPES | TEXT | VARCHAR |
BIT STRING TYPES | TEXT | VARCHAR |
TEXT SEARCH TYPES | TEXT | VARCHAR |
COMPOSITE TYPES | TEXT | VARIANT |
RANGE TYPES | TEXT | VARCHAR |
DOMAIN TYPES | TEXT | VARCHAR |
PG_LSN TYPE | TEXT | VARCHAR |
PSEUDOTYPES | TEXT | VARCHAR |
| Blobs | ||
BYTEA | BYTEA | BINARY |
| Sets | ||
ARRAYS | ARRAY | ARRAY |