[Qgis-user] Saving/Loading styles in Postgis

[DelazJ]

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 <a.neumann at carto.net>:

> 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
> Qgis-user at lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160728/cd06dc11/attachment.html>