I am trying to import some shapefiles into postgis. Now I have an example database within my download of postgis. In this database I can import the shapefile by changing the DBF file character encoding to LATIN1, from the default UTF-8.
When I create my own database and schema the same pattern does not work. The error message received when I use LATIN1 is:
Importing with configuration: gem_2014, public, geom, C:\Users\Sven\Folderstructuur_GIS_Viewer\Brondata_CBS\gem_2014.shp, mode=c, dump=1, simple=0, geography=0, index=1, shape=1, srid=28992
Shapefile type: Polygon
PostGIS type: MULTIPOLYGON[2]
Failed SQL begins: "SET CLIENT_ENCODING TO UTF8;
SET STANDARD_CONFORMING_STRINGS TO ON;
BEGIN;
CREATE TABLE "public"."gem_2014" (gid serial,
"gm_code" varchar(6),
"gm_naam" varchar(60),
"water" varchar(4),
"aant_inw" numeric(10,0),
"aant_man" numeric(10,0),
"aant_vrouw" nume"
Failed in pgui_exec(): ERROR: function addgeometrycolumn(unknown, unknown, unknown, unknown, unknown, integer) does not exist
LINE 46: SELECT AddGeometryColumn('public','gem_2014','geom','28992',...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
Shapefile import failed.
When I use UTF-8 it gives:
Importing with configuration: gem_2014, public, geom, C:\Users\Sven\Folderstructuur_GIS_Viewer\Brondata_CBS\gem_2014.shp, mode=c, dump=1, simple=0, geography=0, index=1, shape=1, srid=28992
Shapefile type: Polygon
PostGIS type: MULTIPOLYGON[2]
Failed SQL begins: "SET CLIENT_ENCODING TO UTF8;
SET STANDARD_CONFORMING_STRINGS TO ON;
BEGIN;
CREATE TABLE "public"."gem_2014" (gid serial,
"gm_code" varchar(6),
"gm_naam" varchar(60),
"water" varchar(4),
"aant_inw" numeric(10,0),
"aant_man" numeric(10,0),
"aant_vrouw" nume"
Failed in pgui_exec(): ERROR: function addgeometrycolumn(unknown, unknown, unknown, unknown, unknown, integer) does not exist
LINE 46: SELECT AddGeometryColumn('public','gem_2014','geom','28992',...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
Shapefile import failed.
For anyone trying to reproduce the situation I am using the following dataset: gem_2014 which can be downloaded from the Dutch national bureau for statistics: http://www.cbs.nl/nl-NL/menu/themas/dossiers/nederland-regionaal/publicaties/geografische-data/archief/2015/wijk-en-buurtkaart-2014-art.htm
I have postgres/gis 9.2
I am especially curious to why it does not work. Because I am planning to work more with Postgis I'd like to understand the problem I have now.
CREATE EXTENSION postgis;