Khurram Niaz Sheikh wrote:
[CC-d to postgis-users list]
Hi Mark,
Can u plz help me on this, I have just installed to evaluate postgres, I
have the data in shape format and wish to convert to postgres format,
when I try to do it using shp to postgres importer it gives me error
Connecting: user=postgres password=****** port=5432 host=localhost
dbname=postgres
Connection succeeded.
Connection: user=postgres password=****** port=5432 host=localhost
dbname=postgres
Destination: public.postgrestest
Source File: D:\My Documents\Data\postgres\postgrestest
Shapefile type: Arc
Postgis type: MULTILINESTRING[2]
Failed SQL begins: "SET CLIENT_ENCODING TO UTF8;
SET STANDARD_CONFORMING_STRINGS TO ON;
BEGIN;
CREATE TABLE "public"."postgrestest" (gid serial PRIMARY KEY,
"road_id" int4,
"priority" int2,
"name" varchar(250),
"geography" varchar(50));
SELECT AddGeometryColumn('public','po"
Failed in pgui_exec(): ERROR: function addgeometrycolumn(unknown,
unknown, unknown, unknown, unknown, integer) does not exist
LINE 9: SELECT AddGeometryColumn('public','postgrestest','the_geom',...
^
HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
Shapefile import failed.
Can uplz give me solution of this issue.
Hi Khurram,
Please email the list directly in future since it is much more likely
that someone will be able to help you.
Note that the in-built postgres database is for
maintenance/administration only - you need to create yourself a new
database and load postgis.sql into it, as per the manual here:
http://postgis.refractions.net/documentation/manual-1.5/ch02.html#id2797624.
HTH,
Mark.
--
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063
Sirius Labs: http://www.siriusit.co.uk/labs
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
