上QQ阅读APP看书，第一时间看更新
The shp2pgsql GUI version
shp2pgsql also has a GUI version. In order to use it, when in PgAdmin, simply choose Plugins | PostGIS Shapefile and DBF loader 2.2 (the version may vary); the following import wizard will be displayed:
In pgAdmin 4, accessing the shapefile loader GUI may not be so obvious. To trigger the tool, try typing shp2pgsql-gui in the shell/command line.
Similar to the cmd version of the utility, you can specify the schema, and you should specify the SRID.
The nice thing about the GUI version of shp2pgsql is that it lets one import multiple files at once.
In the options dialogue, you can specify data encoding, decide whether or not you would like to create a spatial index after importing, choose geography over geometry, and so on:
