数据仓库服务 GaussDB(DWS)-JSON类型:类型对照

时间：2025-02-12 15:05:07

类型对照

输入示例JSON

  
       CREATE TABLE IF NOT EXISTS `runoob_dataType_test`(    `dataType_1` INT,    `dataType_2` VARCHAR,    `dataType_3` JSON);ALTER TABLE `runoob_dataType_test` ADD COLUMN `dataType_4` JSON NOT NULL;ALTER TABLE `runoob_dataType_test` CHANGE COLUMN `dataType_4` `dataType_5` JSON NOT NULL;

输出示例

  
       CREATE TABLE IF NOT EXISTS "public"."runoob_datatype_test"(  "datatype_1" INTEGER,  "datatype_2" VARCHAR,  "datatype_3" JSONB)  WITH ( ORIENTATION = ROW, COMPRESSION = NO )  NOCOMPRESS  DISTRIBUTE BY HASH ("datatype_1");ALTER TABLE  "public"."runoob_datatype_test"ADD  COLUMN "datatype_4" JSONB;ALTER TABLE "public"."runoob_datatype_test" CHANGE COLUMN "datatype_4" "datatype_5" JSONB;