更新时间：2025-11-15 GMT+08:00
openGauss 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 | - |
父主题：数据类型转换
