[Qgis-user] Styles and PostgreSQL

[Bernhard Ströbl]

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
> 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
>



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

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