--添加字段和备注
alter table prm_letter_merge add varchar(324) DEFAULT null;
alter table prm_letter_merge add url2 varchar(324) DEFAULT null;
COMMENT ON COLUMN public.prm_letter_merge.url1 IS '云存储路径';
COMMENT ON COLUMN public.prm_letter_merge.url2 IS '云存储路径';
--修改字段长度
ALTER TABLE prm_letter_merge MODIFY COLUMN url varchar(900);
ALTER TABLE prm_letter_merge alter COLUMN url type character varying(1000);
--删除字段
ALTER TABLE prm_letter_merge DROP COLUMN url1;
ALTER TABLE prm_letter_merge DROP COLUMN url2;
--创建索引
Create Index bill_id_prm_prom_bill_index on prm_prom_bill(bill_id);