I have a shape file, I opened it in QGIS that has columns in attribute table named
- CITY_NAME, POPULATION
and I have a database table in Posqgresql that has columns named
- gid (primary key), city_name, population, geom
Database colums are lowercased names, is this is a problem?
And I want to load shapefile data in existing postgresql database table via shp2pgsql.
shp2pgsql "file.shp" public.cities | -U postgres -a mydb
gives error, Why this error occuring I did not understand. I am giving parameters right.