postgis导入导出shpfile

pgsql2shp -f /home/inspur/chn.shp -h localhost -u postgres -P postgres -p 5432 gis "select * from public.ah_road_slice_v";

shp2pgsql -s 4326 -c -N skip -T nocc -X nocc -W UTF-8 "/home/inspur/zhenjiang0706.shp" public.grid_rsrp | psql -h localhost -p 5432 -d nocc -U postgres

备注：先切换到postgres账户下，才能看到完整的帮助