I'm trying to import a shapefile into a PostGIS database using the graphical importer. I just installed POSTGRESQL, and PostGIS. The GUI looks like this:
After testing that my database worked, I chose the shapefile that I wanted to upload, and then received a message that it had failed to import.
Are there any good tutorials or instructions about how to do this?
Thanks in advance.
As you see, -S key would try to generate simple geometries instead of MULTI geometries. BUT Will only succeed if all the geometries are actually single. Your case is multipolygon with 2 parts, so do not use -S.
When trying to import Multigeometries, I usually check Generate simple geometries instead of MULTI geometries in the Options (subsection 6 in the tutorial) so import is successful.