Question
How do I resolve the following Shapefile Import error message?
Answer
Sometimes when installing a Postgres database, the extension PostGIS is not successfully installed. This means that if you try to import a table/file with spatial geometry the Importer fails to load the data. To resolve this issue, you simply need to create/install the PostGIS extension correctly.
In PGAdmin using the SQL window run the following script:
CREATE EXTENSION postgis;
The Shapefile Importer will now work correctly.