[Qgis-user] create PostGIS view from QGis layer

[Raymond Nijssen]

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 at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user