[postgis-users] loading shapefiles into postgis db

[Shaq Gbadebo]

Hi,

Thanks a million for your reply, Teachr. But I already tried that, here is 
an exact printout of what is happening.

bash-2.05b$ shp2pgsql 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;
countyregionid | geom | name
----------------+------+------
(0 rows)

emmet=#

I am not sure if I have to specify the path of the shapefile, which I have 
already tried as well-"Maps/COUNTY_region.shp", and did not work.

I created the table countyRegion, before using the shp2pgsql. When I use the 
addgeometrycolumn( ); function on this table, i get an error saying

"relation "public"."countyRegion" does not exist"

I am not sure If this has anything to do with it. If anyone could help by 
telling what exact order of steps to populate this table with the spatial 
data, I would be very grateful.

Any help what so ever is appreciated.

Thanks
Shaq!