pgsql 修改表添加表字段方法

增加、修改参数表
do $$
begin
if not exists
(select * from sys_parameters WHERE productid =1 AND programid = 116001 and paramno = 92) then
INSERT INTO sys_parameters ("id", "productid", "programid", "privilege", "paramno", "name", "value", "defvalue", "description", "parentid", "config", "groupname") VALUES ('2858', '1', '116001', '0', '92', '押金(保证金)', '0', '1', '押金(保证金)', NULL, NULL, NULL); 
end if;
END $$;  


增加表字段
do $$
begin
if not exists
(select * from information_schema.columns where  table_name ='zaj1' and  column_name='eaa01') then
ALTER TABLE zaj1
ADD COLUMN "eaa01" int4;
end if;
END $$;






do $$
begin
if not exists
(select * from sys_mod where code = 'hzwc' and _parentid='416') then
INSERT INTO "public"."sys_mod" ("mod_id", "button_id", "_parentid", "mod_name", "mod_url", "mod_port", "menu_type", "m_state", "code", "icon_cls", "mod_order", "create_time", "update_time", "create_user", "update_user", "language", "hist01") VALUES ('2213', NULL, '416', '会诊完成', NULL, NULL, '1', '0', 'hzwc', 'icon-serverwarn', '1',  NULL, NULL, 'admin', NULL, 'zh-CN', '1');
end if;
END $$;