[postgis-users] loading shapefiles into postgis db

[strk at refractions.net]

On Fri, Mar 04, 2005 at 03:05:07PM +0000, Shaq Gbadebo wrote:
> Thank you for reply;
> 
> Here is what happened when I used that approach;

As long as you get "shape is null" nothing will get fed to psql
so there's no point checking out...
First you should get something read and parsed...
Do you have files actually called COUNTY_region.shp and COUNTY_region.shx ?
--strk;

> 
> bash-2.05b$ shp2pgsql -D "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 "myschema"."countyRegion";
> ERROR:  Namespace "myschema" does not exist
> 
> It does not seem to have had any effectt, or should my myschema have a 
> value?
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users