Hi Peter -
I'm not sure if you're aware of the "Save style as default" function -
So here comes for a Postgres layer
1. Load the layer from Postgres
2. Style the layer
3. Right-click on the layer name in the "Layers" panel
4. Click on "Options" -> Button "Style" in the lower leftmost corner of
the dialog
5. Click on "Save as Default" option
6. This will show a small dialog "Load default style from" and 3 buttons
7. Click the button name "Datasource Database"
From now on, every time you load the specific table from Postgres as a
QGIS layer, it will automatically gets the saved style.
It not only the style - It's every information associated to the layer:
Field definition, attribute form and more.
Med venlig hilsen / Best regards
Bo Victor Thomsen
On 07/04/2025 08.45, peter.berger--- via QGIS-User wrote:
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@lists.osgeo.org
List info:https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe:https://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
