Le portail francophone de la géomatique

Bonjour, je suis débutant en PostgreSQL et PostGIS .  j'ai essayé d'importer des shape files à ma base de données  postgreSQL sous  forme de tables.  J’ai utilisé la commande shp2pgsql (sh2pgsql –d c:\test\europesvg.shp testcl3 | psql testgis) sous dos. j'ai  eu les errures suivantes:
==>
C:\Program Files\PostgreSQL\8.0.0-beta5\bin>shp2pgsql -c c:\test\europesvg.shp t
estcl3 | psql testgis
NOTICE: CREATE TABLE will create implicit sequence "testcl3_gid_seq" for serial
column "testcl3.gid"
CREATE TABLE
[b]ERROR: function addgeometrycolumn("unknown", "unknown", "unknown", "unknown", "
unknown", integer) does not exist
HINT: No function matches the given name and argument types. You may need to ad
d explicit type casts.
BEGIN
ERROR: function geometryfromtext("unknown", integer) does not exist
HINT: No function matches the given name and argument types. You may need to ad
d explicit type casts.
ERROR: current transaction is aborted, commands ignored until end of transactio
n block
ERROR: current transaction is aborted, commands ignored until end of transactio
n block
ERROR: current transaction is aborted, commands ignored until end of transactio
n block
ERROR: current transaction is aborted, commands ignored until end of transactio
n block
ERROR: current transaction is aborted, commands ignored until end of transactio
n block
ROLLBACK
NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "testcl3_pkey"
for table "testcl3"
ALTER TABLE
setval
--------
13
(1 row)
La  table testcl3 a été créée mais elle est vide.

Merci

Dernière modification par jguirim (Thu 18 July 2013 15:19)