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, 2015 at 20:30
  • I already tried,but it doesn't work either :/
    – Kristy
    Sep 22, 2015 at 6:04

2 Answers 2


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.


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.

Your Answer

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

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