[Qgis-user] Doubt with qgis_projects table

Jorge Lopez jorgelopez.physics at gmail.com
Sun Feb 12 09:18:20 PST 2023


HI all

I am curious about how to "decode" the column content for qgis_projects
table that is created when a QGIS project is saved to PostgreSQL server

The reason to "decode" is that column is bytea datatype in pg, and I
pressume that in that column all information regarding styles, visible
layers, db connectioon .. are stored. When I copy that table in another
database, it seems that the database name is mantained there and I would
like to modify or/and recreate that. To do this, instead of regenerating
manually the project, I would like to modify the table.

What I presume is that I need the way that column was generated, Martin
Dobias created this in the core qgis and maybe he can provide some light on
this.

Thanks all

Regards

Jorge

-- 
=========================================
Jorge López Pérez

*Web/GIS programmer*

webpage.: http://jorgelopezph.herokuapp.com
mobile: +34 606 98 70 84
skype: jorgelopez.ph
=========================================
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20230212/80c936a3/attachment.htm>


More information about the QGIS-User mailing list