Hi Tim,
Thanks for pointing me in the right direction.
I just discovered that the "update SQL layer..." (in the layer's context
menu) does the trick in a non-automated but convenient way.
In that specific dialog I see both the layer's filter definition (which
is a client-side filter) as well
Hi Gert-Jan,
yes - this is done via:
QGISDatabase menu dropdown --> DB Manager --> select your PostGIS
database --> database dropdown, SQL window --> either script your 'view'
here, or select the SQL query builder dialogue --> select 'Create View'
is this what you wanted?
Tim
On Thu, Apr
Hi Tim and Raymond,
Perhaps I'd explain a little more:
The QGis database tool (as Tim suggests) converts my QGis layer
"myLayer" (= a postgis table "myTable" with a QGis filter ("myFilter"
applied to it) to a new postgis *table*
I was hoping to find an (automated!) way to convert the layer to
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
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
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
