Database Reference
In-Depth Information
>mkdir out_shapefiles
>export_shapefiles.bat
"Generating shapefile AL.shp for country
Albania (AL) containing 66 features"
"Generating shapefile DZ.shp for country
Algeria (DZ) containing 361 features"
…
"Generating shapefile ZW.shp for country
Zimbabwe (ZW) containing 179 features"
7. TrytoopenacoupleoftheseoutputshapefilesinyourfavoriteDesktopGIS.
The following screenshot shows you how they look in QGIS:
8. Now, you will do the round trip, uploading all of the generated shapefiles to
PostGIS.Youwilluploadallofthefeaturesforeachshapefileandincludethe
upload datetime and the original shapefile name. First, create the following
PostgreSQL table, where you will upload the shapefiles:
postgis_cookbook=# CREATE TABLE
chp01.hs_uploaded