生成表的DDL语句有字段描述和表名描述

CREATE TABLE public.goods1 (
id int8 NOT NULL, – id
“name” varchar(64) NULL, – 货物名称
“storage” int4 NULL, – 仓库
goodstype int4 DEFAULT 0 NOT NULL, – 货物类型
remark varchar(64) NULL, – 备注
target_value numeric(18, 6) NULL, – 目标值
target_value_string varchar(64) NULL, – 目标值字符串
target_big numeric(18, 6) NULL,
network varchar(64) NULL, – 网络
worker_id int8 NULL, – 员工表id
sort int4 NULL, – 排序
count int4 NULL, – 数量
CONSTRAINT goods1_unique_id UNIQUE (id)
);
COMMENT ON TABLE public.goods1 IS ‘仓库表1’;

– Column comments

COMMENT ON COLUMN public.goods1.id IS ‘id’;
COMMENT ON COLUMN public.goods1.“name” IS ‘货物名称’;
COMMENT ON COLUMN public.goods1.“storage” IS ‘仓库’;
COMMENT ON COLUMN public.goods1.goodstype IS ‘货物类型’;
COMMENT ON COLUMN public.goods1.remark IS ‘备注’;
COMMENT ON COLUMN public.goods1.target_value IS ‘目标值’;
COMMENT ON COLUMN public.goods1.target_value_string IS ‘目标值字符串’;
COMMENT ON COLUMN public.goods1.network IS ‘网络’;
COMMENT ON COLUMN public.goods1.worker_id IS ‘员工表id’;
COMMENT ON COLUMN public.goods1.sort IS ‘排序’;
COMMENT ON COLUMN public.goods1.count IS ‘数量’;