Hi,

the relation is public.layer_styles. The problem is the xml fields. I once noted for myself to
SET XML OPTION DOCUMENT;
prior to importing the dump. Didn't do it for a while so I am not sure if it works. Another option is to dump layer_styles as plain SQL and then import it into the other machine.

Bernhard

Am 14.01.2016 um 19:30 schrieb Roberto Jesús Dip:
Hi,

I use QGIS 2.12.2 and PostgreSQL 9.5 + PostGIS 2.1.8 (Windows x64).

I´ve saved styles using the option 'Save in database (postgres)'.

It works fine when I add a table to another project with 'Add to
canvas', it brings the style associated with the table.

But when I backup a schema and restore it in another machine I lose the
styles.

Where are stored the styles? Can I move a schema or a database to
another machine without losing the styles?

Thanks a lot for your answer!

Greetings,
Roberto.




_______________________________________________
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




__________ Information from ESET Mail Security, version of virus signature 
database 12872 (20160115) __________

The message was checked by ESET Mail Security.
http://www.eset.com


_______________________________________________
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

Reply via email to