Feature request #9067

Lower case names of fields when importing a shape by DBManager

Added by Moreno Comelli over 3 years ago. Updated about 1 year ago.

Status:OpenStart date:11/15/2013
Priority:NormalDue date:
Assignee:-% Done:


Target version:Future Release - Lower Priority
Platform: Resolution:
Platform version: Pull Request or Patch supplied:No
Status info: Tag:


When importing a shape in Postgis by DBManager, the names of fields are switched to lower case.
It would be better leaving the choice to the user, adding a checkbox in the UI.

shp2pgsl-gui_preserver-case.png (95.5 KB) Larry Shaffer, 02/09/2016 11:20 AM


#1 Updated by Paolo Cavallini over 3 years ago

  • Resolution set to wontfix
  • Status changed from Open to Closed

This is made on purpose, to avoid putting all the fields in queries between ''.
This is also the shp2pgsl choice. Too many options are confusing for users.

#2 Updated by Larry Shaffer about 1 year ago

  • Resolution deleted (wontfix)
  • Target version set to Future Release - Lower Priority
  • Status changed from Closed to Open
  • File shp2pgsl-gui_preserver-case.png added


I am reopening this. While I understand why the lower case change is done, there is a precedence set by the shp2pgsl -k option and the shp2pgsl-gui with its "Preserve case of column names" option (see attachment).

There should probably be a user-configurable option checkbox for "Preserve case of column names" when importing to DB Manager. This may mean updating the underlying code to support this (I did not investigate).

Also note: when using DB Manager's Create table action case is preserved for new column names.

Also available in: Atom PDF