更新一个表中的geometry到另外一个表的geometry，把一个表内容完全插入一个表中

INSERT INTO public.sys_project_report(report_desc, create_time, update_time, project_id, report_local_path)
SELECT report_desc, create_time, update_time, project_id, report_local_path FROM public.sys_project_report_old;

UPDATE z_sys_region4532
SET geom = (SELECT geom FROM z_sys_whole WHERE z_sys_whole.gid=9)
WHERE gid = 9;

shp文件存在自相交情况，geom存在自相交处理语句
UPDATE z_landplan4532 SET geom = ST_MakeValid(geom) WHERE ST_IsValid(geom) = false;