7

I would like to write a Python macro that upon opening my QGIS project file will reload the default style for each layer from the PostgreSQL 'layer_style' table. I have had a look at the documentation and can only work out how this is done from a SQLite db or .qml file.

Any pointers?

Improve this question
3
  • Matt, from QGIS 2.0, It will be possible to save layer styles in Postgresql\postgis database. I know it's not the same, but maybe it solves your need. Take a look here https://www.youtube.com/watch?feature=player_embedded&v=zC-_AmmGTQ8
    – Alexandre Neto
    Jun 27, 2013 at 8:53
  • 2
    I have done that, I would like to know if it is possible to reload the default styles from the postgresql layer_style table using Python.
    – Matt
    Jun 27, 2013 at 9:21
  • Sorry, I misunderstood it.
    – Alexandre Neto
    Jun 27, 2013 at 9:24

1 Answer 1

Reset to default
0

Resurrecting the topic with QGIS 3.0 :). Looking at the QgsVectorLayer API documentation instead of QgsMapLayer API, you have the answer. You can use method saveStyleToDatabase

There are related recipes to manipulate styles in PostgreSQL database from QGIS Python tests including saveStyleToDatabase case at https://github.com/qgis/QGIS/blob/master/tests/src/python/test_provider_postgres.py#L1553

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.