数据仓库服务 GaussDB(DWS)-字段名重命名:保留关键字作字段名

时间:2025-02-12 15:04:59

保留关键字作字段名

GaussDB (DWS)中保留关键字作字段名需要加双引号,目前工具支持的保留关键字有desc、checksum、operator、size等。

输入示例

1234567
CREATE TABLE `desc` (    user char,    checksum int,    operator smallint,    desc char,    size bigint);

输出示例

1234567
CREATE TABLE "public"."desc" (  "user" CHAR(4),  "checksum" INTEGER,  "operator" SMALLINT,  "desc" CHAR(4),  "size" BIGINT) WITH (ORIENTATION = ROW, COMPRESSION = NO) NOCOMPRESS DISTRIBUTE BY HASH ("user");
support.huaweicloud.com/tg-dws/dws_16_0163.html