-- 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)