I am trying to load a shapefile (http://dds.cr.usgs.gov/pub/data/nationalatlas/statesp020_nt00032.tar.gz) into PostGIS 2.0.1 using pgAdmin3's PostGIS Shapefile Import/Export Tool.
However its not allowing me to import the shapefile, showing the error messages below. Any idea what happen?
Output from PostGIS Shapefile Import/Export Tool
============================== Importing with configuration: statesp020, staging, geom, C:\gisdata\statesp020_nt00032\statesp020, mode=c, dump=1, simple=0, geography=0, index=0, shape=1, srid=4269 Shapefile type: Polygon PostGIS type: MULTIPOLYGON[2] Failed SQL begins: "SET CLIENT_ENCODING TO UTF8; SET STANDARD_CONFORMING_STRINGS TO ON; BEGIN; CREATE TABLE "staging"."statesp020" (gid serial, "area" float8, "perimeter" float8, "statesp020" float8, "state" varchar(20), "state_fips" varchar(2), "order_adm" int4, "month_adm"" Failed in pgui_exec(): ERROR: function addgeometrycolumn(unknown, unknown, unknown, unknown, unknown, integer) does not exist LINE 15: SELECT AddGeometryColumn('staging','statesp020','geom','4269... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Shapefile import failed.
أكثر...
However its not allowing me to import the shapefile, showing the error messages below. Any idea what happen?
Output from PostGIS Shapefile Import/Export Tool
============================== Importing with configuration: statesp020, staging, geom, C:\gisdata\statesp020_nt00032\statesp020, mode=c, dump=1, simple=0, geography=0, index=0, shape=1, srid=4269 Shapefile type: Polygon PostGIS type: MULTIPOLYGON[2] Failed SQL begins: "SET CLIENT_ENCODING TO UTF8; SET STANDARD_CONFORMING_STRINGS TO ON; BEGIN; CREATE TABLE "staging"."statesp020" (gid serial, "area" float8, "perimeter" float8, "statesp020" float8, "state" varchar(20), "state_fips" varchar(2), "order_adm" int4, "month_adm"" Failed in pgui_exec(): ERROR: function addgeometrycolumn(unknown, unknown, unknown, unknown, unknown, integer) does not exist LINE 15: SELECT AddGeometryColumn('staging','statesp020','geom','4269... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Shapefile import failed.
أكثر...