PostgreSQL->GaussDB
| Data Type (PostgreSQL) | Data Type (GaussDB) | Whether to Support Mapping |
|---|---|---|
| SMALLINT | SMALLINT | Yes |
| INTEGER | INTEGER | Yes |
| BIGINT | BIGINT | 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 |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
