Re: [Qgis-user] create PostGIS view from QGis layer
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 28, 2022 at 9:16 PM gisnederland via Qgis-user <
qgis-user@lists.osgeo.org> wrote:
> 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 a new
> postgis *view*, something like:
>create or replace view "myView"
>as select "myFilter"
>from "myTable"
>
>
>
> Kind regards,
>
> Gert-Jan
>
>
>
> tim dunlevie via Qgis-user schreef op 28-04-2022 14:48:
> > 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,
> > 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
> ___
> 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
Re: [Qgis-user] [GRASS-user] GRASS GIS Unable to load GDAL library
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 Sent: torsdag 28. april 2022 16:38 To: qgis-user ; GRASS user list Subject: [GRASS-user] GRASS GIS Unable to load GDAL library Hi everyone I installed the GRASS GIS and the QGIS at here [cid:image001.png@01D85B22.291EF520] 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 have any idea to solve this problem? Thanks Ming ___ 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] GRASS GIS Unable to load GDAL library
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 have any idea to solve this problem? Thanks Ming ___ 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
Re: [Qgis-user] create PostGIS view from QGis layer
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 a new
postgis *view*, something like:
create or replace view "myView"
as select "myFilter"
from "myTable"
Kind regards,
Gert-Jan
tim dunlevie via Qgis-user schreef op 28-04-2022 14:48:
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,
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
___
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
Re: [Qgis-user] create PostGIS view from QGis layer
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
Re: [Qgis-user] create PostGIS view from QGis layer
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] create PostGIS view from QGis layer
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
