Hi, Andreas, Styles are indeed saved in the public schema, in a table named "layer_styles". I had never created such a table so I assume it's created by QGIS.
Just made a test and rename my current "layer_styles" table. Then I successfully save a new layer style in PG from QGIS 2.16: a new table "layer_styles" has automatically been created in the public schema. HTH, Harrissou 2016-07-28 17:38 GMT+02:00 Neumann, Andreas <[email protected]>: > Hi, > > I have never used the Saving/Loading of styles in Postgis (see > http://docs.qgis.org/2.14/en/docs/user_manual/working_with_vector/vector_properties.html#storing-style-in-a-file-or-a-database > ) > > Do I have to create a special styling table for it to enable this? > > Because when I try to save it (QGIS 2.16) I get an error message along the > lines that my user may not have permissions to save the style. However, I > am trying to save the style with a user that has full administrator rights > in Postgis. > > In what schema and table are the styles stored? I assume in the public > schema. Will QGIS automatically create a styling table or do I have to > create one myself? > > Thank you for any hints! > > Andreas > > > > > _______________________________________________ > Qgis-user mailing list > [email protected] > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user >
_______________________________________________ Qgis-user mailing list [email protected] List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
