[postgis-users] loading shapefiles into postgis db

[Shaq Gbadebo]

Thanks again for your reply Jean David. Here is what happens; when I try 
that approach:

emmet=# DROP TABLE countyRegion;
DROP TABLE
emmet-# \q
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 countyRegion;
ERROR:  Relation "countyregion" does not exist

Imply that the table has not been created with the shp2pgsql command.  
Should the table not be created manually?
Your reply will be appreciated.