[postgis-users] loading shapefiles into postgis db

Shaq Gbadebo s_gbadebo at hotmail.com
Fri Mar 4 10:04:59 PST 2005


I created the schema carried out the shp2pgsql  command. This seems to work 
fine

bash-2.05b$ shp2pgsql COUNTY_region myschema.countyRegion | psql -d emmet
NOTICE:  CREATE TABLE will create implicit sequence 'countyregion_gid_seq' 
for SERIAL column 'countyregion.gid'
CREATE TABLE
                                          addgeometrycolumn
-----------------------------------------------------------------------------------------------------
Geometry column the_geom added to table myschema.dualcar WITH a SRID of -1 
and type MULTILINESTRING
(1 row)

UNtil this appears

BEGIN
ERROR:  Relation "countyregion" does not exist
ERROR:  current transaction is aborted, queries ignored until end of 
transaction block

Does this mean I also have to create a table called countyRegion.

THanks

Shaq.





More information about the postgis-users mailing list