Feature request #4565

storing qml file in the postgis table comments

Added by Rhys Stewart over 5 years ago. Updated over 1 year ago.

Status:Closed Start Date:11/24/2011
Priority:Normal Due date:
Assigned to:- % Done:

100%

Category:Symbology
Target version:Future Release - Nice to have
Platform: Resolution:
Platform version: Pull Request or Patch supplied:No
Status info: Tag:

Description

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.

History

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...
Régis

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 Paolo Cavallini over 5 years ago

  • Category set to Symbology

Updated by Giovanni Manghi over 5 years ago

  • Target version set to Version 1.7.4

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

Hello,

bug triage...

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 !

Updated by Médéric RIBREUX over 1 year ago

  • Status changed from Open to Closed
  • % Done changed from 0 to 100

Also available in: Atom