Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

storing qml file in the postgis table comments #14477

Closed
qgib opened this issue Nov 24, 2011 · 9 comments

Comments

@qgib
Copy link
Contributor

commented Nov 24, 2011

Author Name: Rhys Stewart (@rhysallister)
Original Redmine Issue: 4565

Redmine category:symbology


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.

@qgib

This comment has been minimized.

Copy link
Contributor Author

commented Nov 24, 2011

Author Name: Regis Haubourg (@haubourg)


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

@qgib

This comment has been minimized.

Copy link
Contributor Author

commented Nov 24, 2011

Author Name: Giuseppe Sucameli (@brushtyler)


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.

@qgib

This comment has been minimized.

Copy link
Contributor Author

commented Nov 24, 2011

Author Name: Rhys Stewart (@rhysallister)


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.

@qgib

This comment has been minimized.

Copy link
Contributor Author

commented Dec 9, 2011

Author Name: Paolo Cavallini (@pcav)


  • category_id was configured as Symbology
@qgib

This comment has been minimized.

Copy link
Contributor Author

commented Dec 16, 2011

Author Name: Giovanni Manghi (@gioman)


  • fixed_version_id was configured as Version 1.7.4
@qgib

This comment has been minimized.

Copy link
Contributor Author

commented Apr 15, 2012

Author Name: Giovanni Manghi (@gioman)


  • fixed_version_id was changed from Version 1.7.4 to Version 2.0.0
@qgib

This comment has been minimized.

Copy link
Contributor Author

commented Oct 6, 2012

Author Name: Pirmin Kalberer (Pirmin Kalberer)


  • fixed_version_id was changed from Version 2.0.0 to Future Release - Nice to have
@qgib

This comment has been minimized.

Copy link
Contributor Author

commented Nov 9, 2015

Author Name: Médéric RIBREUX (Médéric RIBREUX)


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 !

@qgib

This comment has been minimized.

Copy link
Contributor Author

commented Nov 9, 2015

Author Name: Médéric RIBREUX (Médéric RIBREUX)


  • done_ratio was changed from 0 to 100
  • status_id was changed from Open to Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
1 participant
You can’t perform that action at this time.