postgresql - Error when import shapefile on postgis with shp2pgsql (unable to open shapefile)? -

postgresql - Error when import shapefile on postgis with shp2pgsql (unable to open shapefile)? -

i utilize postgresql 9.1, postgis 2.0.1. importing shapefiles database, utilize shp2pgsql. have tried many ways importing theses shapefiles (shp2pgsql -i roads.shp public.roads | psql -d map), result always:

unable open roads.shp or roads.shp. roads: dbf file (.dbf) can not opened.

how solve problem?

a "shapefile" more 1 file (i.e., more .shp file). create sure of files in same folder when using gis software, including shp2pgsql.

the minimum required files, sharing mutual prefix, are:

.shp — geometry data .dbf — attribute data .shx — geometry index file

other files may include: .prj, .sbn, .sbx, .fbn, .fbx, .ain, .aih, .ixs, .mxs, .atx, .shp.xml, , .cpg.

postgresql postgis