postgreSQL通过postgis导入空间数据问题
通过postgis导入空间数据时出现以下问题:
Connecting: host=localhost port=5432 user=postgres password='***' dbname=costragis
==============================
Importing with configuration: 2004shuitimian, public, geom, E:\0422SHPshpfile\mian\2004shuitimian, mode=c, dump=1, simple=0, geography=0, index=1, shape=1, srid=0
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"."2004shuitimian" (gid serial,
"id" int4,
"aera" numeric,
"name" varchar(50));
ALTER TABLE "public"."2004shuitimian" ADD PRIMARY KEY (gid);
SELECT AddGeometryC"
Failed in pgui_exec(): 錯誤: 函式 addgeometrycolumn(unknown, unknown, unknown, unknown, unknown, integer) 不存在
LINE 9: SELECT AddGeometryColumn('public','2004shuitimian','geom','0...
^
HINT: 沒有符合指定之名稱和參數型別的函式。您可能需要加入明確型別轉換。
Shapefile import failed.
咨询各位大师,什么原因
初学者,除去使用postgis导入空间数据外,还有什么方法将数据导入postgresql中呢!