example:
CREATE TABLE "deviceparts" (
"deviceid" int8 NOT NULL,
"partid" int8 NOT NULL,
"partname" varchar(255),
"partlocal" varchar(255),
"mattercode" varchar(255),
"devicecode" varchar(255)
)
COMMENT ON TABLE deviceparts IS '设备零件表';
COMMENT ON COLUMN deviceparts.deviceid IS '设备id';
COMMENT ON COLUMN deviceparts.partid IS '零件id';
COMMENT ON COLUMN deviceparts.partname IS '零件name';
COMMENT ON COLUMN deviceparts.partlocal IS '零件位置';
COMMENT ON COLUMN deviceparts.mattercode IS '物料/代码';
COMMENT ON COLUMN deviceparts.devicecode IS '设备/代码';
PS:
postgres 建表的话,表名全部小写, 不然的话,添加注释(comment)的时候,会找不到表