Feature request #9067

Lower case names of fields when importing a shape by DBManager

Added by Moreno Comelli over 10 years ago. Updated about 7 years ago.

Category:DB Manager
Pull Request or Patch supplied:No Resolution:fixed/implemented
Easy fix?:No Copied to github as #:17714


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, 2016-02-09 11:20 AM


#1 Updated by Paolo Cavallini over 10 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 over 8 years ago

  • Target version set to Future Release - Lower Priority
  • Resolution deleted (wontfix)
  • 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.

#3 Updated by Giovanni Manghi about 7 years ago

  • Easy fix? set to No

#4 Updated by Regis Haubourg about 7 years ago

  • Description updated (diff)
  • Status changed from Open to Closed
  • Resolution set to fixed/implemented

Hi, in 2.18, there is a checkbox "Convert field names to lowercase".

Also available in: Atom PDF