数据库和应用迁移 UGO-PostgreSQL To GaussDB 数据类型转换说明

时间：2024-04-17 18:15:41

PostgreSQL To GaussDB 数据类型转换说明

源数据库数据类型	转换后数据类型	相关的转换配置
SMALLINT	SMALLINT	-
INTEGER	INTEGER	-
BIGINT	BIGINT	-
INTEGER	INTEGER	-
REAL	REAL	-
DOUBLE PRECISION	DOUBLE PRECISION	-
NUMERIC	NUMERIC	-
CHARACTER VARYING	CHARACTER VARYING	字符数据类型转换选择配置项的值为“扩展字符数据类型char/varchar长度。”，可与DRS转换后在GaussDB 存储等价。
CHARACTER	CHARACTER	字符数据类型转换选择配置项的值为“扩展字符数据类型char/varchar长度。”，可与DRS转换后在GaussDB 存储等价。
BIT	BIT	-
BIT VARYING	BIT VARYING	-
BOOLEAN	BOOLEAN	-
BYTEA	BYTEA	-
TEXT	TEXT	-
TIME WITHOUT TIME ZONE	TIME WITHOUT TIME ZONE	-
TIME WITH TIME ZONE	TIME WITH TIME ZONE	-
TIMESTAMP WITHOUT TIME ZONE	TIMESTAMP WITHOUT TIME ZONE	-
TIMESTAMP WITH TIME ZONE	TIMESTAMP WITH TIME ZONE	-
INTERVAL	INTERVAL	-
CIDR	CIDR	-
PATH	PATH	-
BOX	BOX	-
LSEG	LSEG	-
MACADDR	MACADDR	-
POINT	POINT	-
POLYGON	POLYGON	-
INET	INET	-
TSQUERY	TSQUERY	-
TSVECTOR	TSVECTOR	-
UUID	UUID	-
JSON	JSON	-
JSONB	JSONB	-