[postgis-users] loading shapefiles into postgis db

[TECHER Jean David]

drop the tabel and try

shp2pgsql -D COUNTY_region.shp myschema.countyRegion | psql -d emmet

----------------------------------------------------------------
TECHER Jean David
Responsable Informatique 01MAP
e-mail: davidtecher at yahoo.fr
Bureau: 04 67 45 60 27
Portable: 06 85 37 36 75
site perso : http://techer.pascal.free.fr/postgis/
site pro: http://www.01map.com/download/
K-S:"The greatest trick the devil pulled off was convincing people he didn't
exist"
------------------------------------------------------------
----- Original Message -----
From: "Shaq Gbadebo" <s_gbadebo at hotmail.com>
To: <postgis-users at postgis.refractions.net>
Sent: Friday, March 04, 2005 2:38 PM
Subject: Re: [postgis-users] loading shapefiles into postgis db


> Hi,
>
> Thanks a million for your reply, Teachr. But I already tried that, here is
> an exact printout of what is happening.
>
> bash-2.05b$ shp2pgsql COUNTY_region.shp myschema.countyRegion | psql -d
> emmet
> shape is null
> bash-2.05b$ psql emmet
> Welcome to psql 7.3.4, the PostgreSQL interactive terminal.
>
> Type:  \copyright for distribution terms
>        \h for help with SQL commands
>        \? for help on internal slash commands
>        \g or terminate with semicolon to execute query
>        \q to quit
>
> emmet=# select * from countyRegion;
> countyregionid | geom | name
> ----------------+------+------
> (0 rows)
>
> emmet=#
>
> I am not sure if I have to specify the path of the shapefile, which I have
> already tried as well-"Maps/COUNTY_region.shp", and did not work.
>
> I created the table countyRegion, before using the shp2pgsql. When I use
the
> addgeometrycolumn( ); function on this table, i get an error saying
>
> "relation "public"."countyRegion" does not exist"
>
> I am not sure If this has anything to do with it. If anyone could help by
> telling what exact order of steps to populate this table with the spatial
> data, I would be very grateful.
>
> Any help what so ever is appreciated.
>
> Thanks
> Shaq!
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users