Feature request #9067
Lower case names of fields when importing a shape by DBManager
|Assigned to:||-||% Done:||
|Target version:||Future Release - Lower Priority|
|Platform version:||Pull Request or Patch supplied:||No|
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.
Updated by Paolo Cavallini over 3 years ago
- Status changed from Open to Closed
- Resolution set to wontfix
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.
Updated by Larry Shaffer about 1 year ago
- File shp2pgsl-gui_preserver-case.png added
- Status changed from Closed to Open
- Target version set to Future Release - Lower Priority
- Resolution deleted (
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