I have an ESRI Shapefile that I can open in ArcMap and QGIS and show the attributes fine. However when I try to load to PostGIS using ogr2ogr I get an error saying
ERROR 1: ERROR: zero-length delimited identifier at or near """" LINE 1: ALTER TABLE "attribute" ADD COLUMN "" VARCHAR(5)
I used ogrinfo -al File.shp and it lists all 20 records fine but none of the attributes seem to come through.
I have opened the dbf file in Excel and its fine and have even parsed the dbf header using python and it is exactly the same header output as a previous shapefile which correctly loads.
Can anyone help me understand why ogr2ogr is having an issue parsing the file?