Feature request #4565
storing qml file in the postgis table comments
|Assigned to:||-||% Done:||
|Target version:||Future Release - Nice to have|
|Platform version:||Pull Request or Patch supplied:||No|
It would be very cool if the postgis provider had the option to save the style for a layer/table (the qml file) in the comments of a table. And then optionally load the layer with the associated qml file.
Updated by Regis Haubourg over 5 years ago
I agree, very useful feature. The xml code should be appended to the existing comment, and not erase it...
Updated by Giuseppe Sucameli over 5 years ago
Why storing it in the comment of the table? And how to make it working with tables with more geometry columns? Maybe using the comment of geometry field instead?
IMHO would be better a new metadata table containing the relation between table + geomcol and the style.
Updated by Rhys Stewart over 5 years ago
The comments of the geometry field would even be better, I honestly didn't realize that fields could have comments!!!!
I prefer storing it in the table rather than a separate metatable because I think it would be easier to export/dump/backup individual tables complete with the style in the table or field comments as opposed to exporting the table in question plus the metadata table.
Updated by Giovanni Manghi about 5 years ago
- Target version changed from Version 1.7.4 to Version 2.0.0
Updated by Pirmin Kalberer over 4 years ago
- Target version changed from Version 2.0.0 to Future Release - Nice to have
Updated by Médéric RIBREUX over 1 year ago
I think that this feature is now completely integrated into QGIS PostgreSQL provider and Spatialite too. For PostgreSQL, style is stored into a dedicated table (layer_styles).
We can close this feature request !
Also available in: Atom