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 Ming,
Could you please try to install the “gdal-303-runtime” package (when you choose
advanced install, it is in the libs section). If I am not mistaken, this is a
glitch that should be fixed with the upcoming GRASS GIS 8.0.2 release.
Cheers
Stefan
From: grass-user On Behalf Of ming han
Hi everyone
I installed the GRASS GIS and the QGIS at here
[image: image.png]
I use all default options and when I tried to use GRASS GIS,I got the
following error.
GRASS_INFO_ERROR(17904,1): Unable to load GDAL library
GRASS_INFO_END(17904,1)
Would you please let me know if you
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