Maybe it's a stupid question, but I don't know how to connect layer style with database in QGIS.

When I save the style to postgres database in QGIS, it automatically saves the style in the table layer_styles in public scheme.

But when I want to reconnect it to the layer, it shows only all other layer styles without required one and in the window 'styles related to the layer' there is a message "No styles found in the database". Do you know, where the problem could be?

enter image description here

enter image description here

enter image description here

  • try 'use as default style for this layer' option before saving to the db – Mapperz Sep 21 '15 at 20:30
  • I already tried,but it doesn't work either :/ – Kristy Sep 22 '15 at 6:04

Grant & owner problem? I just fixed a similar problem with the layer_styles by correcting the owner from user A to the user group containing users A and B.

| improve this answer | |

From your screenshot I see that f_table_catalog field is blank. Mine has the database name in that field & if I delete it I get the same behaviour you are describing.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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