[postgis-users] loading shapefiles into postgis db

[strk at refractions.net]

shp2pgsql will NOT attempt to create a schema for you, so do it
youself before sourcing shp2pgsql output.
--strk;

On Fri, Mar 04, 2005 at 05:26:15PM +0000, Shaq Gbadebo wrote:
> Hi,
> Whoa!!!.....You guys are so helpful.I really appreciate this. Markus that 
> website worked like magic and created the .shx files easily. Strk thanks 
> for helping to find my problem. I tried the shp2pgsql again I did not get 
> the shape is null message again, whcih was a good sign. I got the error 
> below
> 
> 
> bash-2.05b$ shp2pgsql -D "COUNTY_region.shp" myschema.countyRegion | psql 
> -d emmet
> ERROR:  Namespace "myschema" does not exist
> NOTICE:  Invalid schema name - using current_schema()
> WARNING:  Error occurred while executing PL/pgSQL function addgeometrycolumn
> WARNING:  line 56 at execute statement
> ERROR:  Relation "public"."countyregion" does not exist
> ERROR:  Namespace "myschema" does not exist
> ERROR:  parser: parse error at or near "0" at character 1
> ERROR:  parser: parse error at or near "MULTIPOLYGON" at character 1
> ERROR:  parser: parse error at or near "MULTIPOLYGON" at character 1
> ERROR:  parser: parse error at or near "MULTIPOLYGON" at character 1
> ERROR:  parser: parse error at or near "MULTIPOLYGON" at character 1
> ERROR:  parser: parse error at or near "MULTIPOLYGON" at character 1
> 
> 
> 
> Which seems to imply, that the table has still not been created. Can anyone 
> please help?
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users