You can also use the QGIS database tool from the menu...to get to the SQL query gui...construct your query through that - add table, add a condition (where blah = blah)...then you have the ability to create a view in the postgis database.....rather than writing sql query using pgadmin etc...
On Thu, 28 Apr 2022, 8:38 pm Raymond Nijssen via Qgis-user, < qgis-user@lists.osgeo.org> wrote: > 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 >
_______________________________________________ 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