[Qgis-user] create PostGIS view from QGis layer

[gisnederland]

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