Feature request #4565

storing qml file in the postgis table comments

Added by Rhys Stewart about 12 years ago. Updated about 8 years ago.

Pull Request or Patch supplied:No Resolution:
Easy fix?:No Copied to github as #:14477


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.


#1 Updated by Regis Haubourg about 12 years ago

I agree, very useful feature. The xml code should be appended to the existing comment, and not erase it...

#2 Updated by Giuseppe Sucameli about 12 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.

#3 Updated by Rhys Stewart about 12 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.

#4 Updated by Paolo Cavallini almost 12 years ago

  • Category set to Symbology

#5 Updated by Giovanni Manghi almost 12 years ago

  • Target version set to Version 1.7.4

#6 Updated by Giovanni Manghi over 11 years ago

  • Target version changed from Version 1.7.4 to Version 2.0.0

#7 Updated by Pirmin Kalberer about 11 years ago

  • Target version changed from Version 2.0.0 to Future Release - Nice to have

#8 Updated by Médéric RIBREUX about 8 years ago


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 !

#9 Updated by Médéric RIBREUX about 8 years ago

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

Also available in: Atom PDF