[Qgis-user] reading and saving styles from qgis in postgres

[Holger Naumann]

Hi,
I organized my postgis database using schema. All users can read all 
data but they can only edit there own tables. If one user save his style 
into the postgres database, its creates the layer_style file in his own 
schema. It is not possible for other users of this database to load this 
style, if they want to view the data of this user.

QGIS uses this sql query:

SELECT styleQML FROM layer_styles WHERE 
f_table_catalog='regionalplanung' AND f_table_schema='rpg_abw' AND 
f_table_name='punkt_darstellung_l2' AND f_geometry_column='the_geom'

But this query fails, because the layer_styles table is located in 
schema 'rpg_abw', the "home" directory of this user.
It is possible, to change the query to SELECT styleQML FROM 
schema.layer_styles WHERE....?

I use QGIS 2.12.


greetings, Holger