Using PostGIS Shapefile Import/Export Manager to import shapefile into database, but it failed.

1
2
3
4
5
6
7
8
==============================
Shapefile type: Point
PostGIS type: POINT[2]
Failed in pgui_exec(): ERROR:  schema "public" does not exist
LINE 4: CREATE TABLE "public"."railwayStation" (gid serial,
                     ^

Shapefile import failed.

Because the database is not a geo database.

1
CREATE EXTENSION postgis;

If get the ERROR:

1
ERROR:  no schema has been selected to create in

excute:

1
CREATE SCHEMA public;