Choco1ove的博客

需求：有一张行政区划表，想只保留中国区域的，中国之外的全部清除1、表结构2、查询出所有【中国区域】的行政区划（递归查询）WITH RECURSIVE r AS (SELECT * FROM tbl_nation_area WHERE id = '185'union ALLSELECT na.* FROM tbl_nation_area na, r WHERE na.pid = r.id )SELECT id FROM r ORDER BY id3、删除除【中国区域】..

备份文件pg_dump -h 127.0.0.1 -p 5432 -U postgres atplatform_2.0 > D:jiangxx/atplatform_2.0.backup恢复文件psql -h 127.0.0.1 -p 5432 -d atplatform_2.0 -U postgres -f D:jiangxx/atplatform_2.0.backup