I am trying to import a shapefile to Postgres using the following:
shp2pgsql c:\location\water_areas.shp water > water.sql
I am receiving the following message:
c:\location\water_areas.shp: shape (.shp) or index file (.shx) can not be opened, will just import attribute data.
Unfortunately I need more than just attribute data. I need the geometry column. Please help. Why won't it open the shapefile for the conversion.