[Qgis-user] Storing and Retrieving Vector Layers with Styles to Postgres DB

[Ludwig Kniprath]

Hello Peter,

everything that users do in QGis can be done by Python scripts, 
including your steps listed below.

There are some difficulties for the desired "one step" solution, f. e. 
the name of the file-based layer must be converted in a valid and unique 
postgis table-name, the fields of the file-based layer must be stored 
with valid postgis field-types and -names and so on...

Taking into account all special features, exceptions and necessary 
settings, this results in a rather complex program, the implementation 
of which may be more complex than the manual implementation in QGis...

Just my two cents...

Ludwig


Am 07.04.25 um 08:45 schrieb peter.berger--- via QGIS-User:
>
> There are serveral steps necessary to store from QGIS a vector layer 
> with his style in a postgres DB. For a big amout of layers this is 
> impracticaI.
>
> Therfore I would do this in one step from QGIS. Is this in any way 
> possible?
>
> *Peter Berger*
>
> Brunnwiesenstrasse 62
>
> 8049 Zürich
>
> Schweiz
>
> mobile +41 79 301 71 54
>
> The several step procedure:
>
> ·*Load the layer*: Import the layer from a vector file into QGIS.
>
> ·*Rename (if necessary)*: Give the layer an appropriate name.
>
> · *Transfer the layer to Postgres*: Drag the layer into the PostgreSQL 
> database. You will find it there with the specific name.
>
> · *Load the layer from Postgres*: Import it back from the PostgreSQL 
> database into QGIS.
>
> · *Assign the style*: Copy the style from the original layer and 
> assign it to the Postgres layer loaded in QGIS.
>
> · *Export the style*: Export the style of the Postgres layer. You will 
> now find an option to save the style with the exact name of the layer 
> in the PostgreSQL database.
>
> · *Delete old layers and reload*: Delete all associated layers and 
> reload the layer from the PostgreSQL database.
>
>
> _______________________________________________
> QGIS-User mailing list
> QGIS-User at lists.osgeo.org
> List info:https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe:https://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20250407/ceb468e3/attachment.htm>