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 |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.