The steps you need to follow to complete this recipe are as follows:
- Create a shapefile from the virtual driver created in the previous recipe using the ogr2ogr command (note that in this case, you do not need to specify the -f option as the shapefile is the default output format for the ogr2ogr command):
$ ogr2ogr global_24h.shp global_24h.vrt
- Generate the SQL dump file for the shapefile using the shp2pgsql command. You are going to use the -G option to generate a PostGIS spatial table using the geography type, and the -I option to generate the spatial index on the geometric column:
$ shp2pgsql -G -I global_24h.shp chp01.global_24h_geographic > global_24h.sql
- Analyze the global_24h.sql file (in Windows, use a text ...