PostgreSQL->GaussDB(DWS)
Data Type (PostgreSQL) | Data Type (GaussDB(DWS)) | Whether to Support Mapping |
|---|---|---|
SMALLINT | SMALLINT | Yes |
INTEGER | INTEGER | Yes |
BIGINT | BIGINT | Yes |
INTEGER | INTEGER | Yes |
REAL | REAL | Yes |
DOUBLE PRECISION | DOUBLE PRECISION | Yes |
NUMERIC | NUMERIC | Yes |
CHARACTER VARYING | CHARACTER VARYING | Yes |
CHARACTER | CHARACTER | Yes |
BIT | BIT | Yes |
BIT VARYING | BIT VARYING | Yes |
BOOLEAN | BOOLEAN | Yes |
BYTEA | BYTEA | Yes |
TEXT | TEXT | Yes |
TIME WITHOUT TIME ZONE | TIME WITHOUT TIME ZONE | Yes |
TIME WITH TIME ZONE | TIME WITH TIME ZONE | Yes |
TIMESTAMP WITHOUT TIME ZONE | TIMESTAMP WITHOUT TIME ZONE | Yes |
TIMESTAMP WITH TIME ZONE | TIMESTAMP WITH TIME ZONE | Yes |
INTERVAL | INTERVAL | Yes |
CIDR | CIDR | Yes |
PATH | PATH | Yes |
BOX | BOX | Yes |
LSEG | LSEG | Yes |
MACADDR | MACADDR | Yes |
POINT | POINT | Yes |
POLYGON | POLYGON | Yes |
INET | INET | Yes |
TSQUERY | TSQUERY | Yes |
TSVECTOR | TSVECTOR | Yes |
UUID | UUID | Yes |
JSON | JSON | Yes |
JSONB | JSONB | Yes |
Parent topic: Mapping Data Types