PostgreSQL 添加字段语句

时间：2020-11-20 17:37:08 收藏：0 阅读：1743

ALTER  table npas.de_indoor ADD COLUMN carrier_configuration varchar(255) DEFAULT null;
COMMENT ON COLUMN "npas"."de_indoor"."carrier_configuration" IS ‘载波配置：载波配置‘;

ALTER  table npas.pl_indoor ADD COLUMN carrier_configuration varchar(255) DEFAULT null;
COMMENT ON COLUMN "npas"."pl_indoor"."carrier_configuration" IS ‘载波配置：载波配置‘;

ALTER  table npas.re_indoor ADD COLUMN carrier_configuration varchar(255) DEFAULT null;
COMMENT ON COLUMN "npas"."re_indoor"."carrier_configuration" IS ‘载波配置：载波配置‘;

ALTER  table npas.st_indoor ADD COLUMN carrier_configuration varchar(255) DEFAULT null;
COMMENT ON COLUMN "npas"."st_indoor"."carrier_configuration" IS ‘载波配置：载波配置‘;

原文：https://www.cnblogs.com/chuyuan/p/14011200.html