[postgis-users] loading shapefiles into postgis db

[strk at refractions.net]

On Fri, Mar 04, 2005 at 01:55:28PM +0000, Shaq Gbadebo wrote:
...
> bash-2.05b$ shp2pgsql -D COUNTY_region.shp myschema.countyRegion 

Is your shapefile name really mixed in case ?
Try quoting "COUNTY_region.shp".

> emmet=# select * from countyRegion;

select * from "myschema"."countyRegion";

--strk;