[postgis-users] loading shapefiles into postgis db

[Shaq Gbadebo]

Thank you for reply;

Here is what happened when I used that approach;

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?