Feature request #4565

storing qml file in the postgis table comments

Added by Rhys Stewart almost 6 years ago. Updated almost 2 years ago.

Status:Closed
Priority:Normal
Assignee:-
Category:Symbology
Pull Request or Patch supplied:No Resolution:
Easy fix?:No

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

#1 Updated by Regis Haubourg almost 6 years ago

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

#2 Updated by Giuseppe Sucameli almost 6 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 almost 6 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 6 years ago

  • Category set to Symbology

#5 Updated by Giovanni Manghi almost 6 years ago

  • Target version set to Version 1.7.4

#6 Updated by Giovanni Manghi over 5 years ago

  • Target version changed from Version 1.7.4 to Version 2.0.0

#7 Updated by Pirmin Kalberer about 5 years ago

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

#8 Updated by Médéric RIBREUX almost 2 years 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 !

#9 Updated by Médéric RIBREUX almost 2 years ago

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

Also available in: Atom PDF