Re: [QGIS-Developer] PostgreSQL execute and load SQL in Processing Modeler

2019-07-31 Thread Nyall Dawson
On Thu, 1 Aug 2019 at 08:17, Pedro Venâncio wrote: > > Hi Harrissou, > > "PostgreSQL execute SQL" can not be input to another algorithm in Processing > Modeler, because it has no output. It is only used to execute SQL directly in > the database. > > "PostgreSQL execute and load SQL" do the

Re: [QGIS-Developer] PostgreSQL execute and load SQL in Processing Modeler

2019-07-31 Thread Pedro Venâncio
Hi Harrissou, "PostgreSQL execute SQL" can not be input to another algorithm in Processing Modeler, because it has no output. It is only used to execute SQL directly in the database. "PostgreSQL execute and load SQL" do the same, but load the result of the SQL query in QGIS, and this one already

Re: [QGIS-Developer] PostgreSQL execute and load SQL in Processing Modeler

2019-07-31 Thread DelazJ
Hi Pedro, Using "PostgreSQL execute SQL" https://docs.qgis.org/testing/en/docs/user_manual/processing_algs/qgis/database.html#postgresql-execute-sql? without the load part Regards, Harrissou Le mer. 31 juil. 2019 à 18:31, Pedro Venâncio a écrit : > Dear all, > > I'm developing a Processing

[QGIS-Developer] PostgreSQL execute and load SQL in Processing Modeler

2019-07-31 Thread Pedro Venâncio
Dear all, I'm developing a Processing Model and I want to run an algorithm (Union) on a specific PostGIS layer. The idea is to have this input layer hardcoded to the Union algorithm. If this layer is stored in a system file (SHP, or any other vector layer format), it is simple, just pointing