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

时间:2024-10-18 19:43:49

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

-

support.huaweicloud.com/usermanual-ugo/ugo_03_0064.html