1.直接导入数据库
shp2pgsql -s "4326" -W "GBK" E:/shape/Road_polyline.shp road_cross| psql -U postgres -h 172.17.40.83 -d test
2.导出sql
shp2pgsql -s "4326" E:/shape/Road_polyline.shp blocks > E:/roadcross/blocks.sql
3.导出sql再导入数据库
1.shp2pgsql -s "4326" -W "GBK" E:/shape/Road_polyline.shp blocks > E:/roadcross/blocks.sql
2.psql -U postgres -h 172.17.40.83 -d test -f E:/roadcross/blocks.sql