Help Center/ Data Replication Service/ Service Overview/ Mapping Data Types/ PostgreSQL->GaussDB

Updated on 2023-10-16 GMT+08:00

View PDF

PostgreSQL->GaussDB

**Table 1** Data type mapping
Data Type (PostgreSQL)	Data Type (GaussDB)	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

Previous topic: DB2 for LUW->GaussDB(DWS)

Next topic: PostgreSQL->GaussDB(DWS)

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.