Hi Gert-Jan,
Not sure how exactly you are filtering your data, but to create views
you can run these queries on your PostgreSQL database using the tool you
like (for example DB-manager in QGIS, or DBeaver or PGAdmin).
In case this is an SQL query filter:
CREATE VIEW blabla1 AS
[your sql select query goes here]
In case it's a 'provider object filter' (in the Source tab of your layer
properties):
CREATE VIEW view_name AS
SELECT * FROM table_name WHERE
[your filter goes here]
Hope this helps,
Raymond
On 28-04-2022 14:09, gisnederland via Qgis-user wrote:
Hi all,
I've got a QGis (3.20) project with (amongst others) 15 layers that all
point to 1 postgis table, but all have a different filter applied (in
QGis).
I'm looking for a convenient way to convert these layers-with-filter to
views in PostGIS, in which the SQL "select"-statement matches the QGis
filter expression.
Any way to do this in QGis, or with other tooling?
Kind regards,
Gert-Jan
_______________________________________________
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