-- 20240703,发布现场,以后sql表变动记录 base.t_fzss_hgxfx 表添加字段了,需重新建表 ALTER TABLE "base"."t_fzss_fzxz" ADD COLUMN "is_delete" bool; COMMENT ON COLUMN "base"."t_fzss_fzxz"."is_delete" IS '是否删除'; UPDATE t_fzss_fzxz SET is_delete=FALSE; --修改坐标系 update vector."TB_TDGY_SJ" set geom= st_setsrid(geom,4326) -- vector新增表 t_table t_table_conversion t_table_filed t_table_filed_relation t_table_inside_outside t_table_res_rule t_table_res_tabel -- vector新增表 -- 生成火葬场图斑 CREATE TABLE "TB_HZC" as SELECT * FROM "TB_GHDK" WHERE lbdm like '%1506%';