[Qgis-user] Loading filtered database table as temp layer

[pathmapper]

Hi Michael,

if it's just about creating a temporay layer as model output, you could 
try to use the "Drop field(s)" algorithm after "PostgreSQL SQL execute 
and load" in your model.

Just choose for the field "Input layer" the algorithm output of the 
"PostgreSQL SQL execute and load" algorithm, leave the "Fields to drop" 
field empty and enter a custom name for "Remaining fields".

You should also set a algorithm dependecy there (so the "Drop field(s)" 
algorithm is executed after "PostgreSQL SQL execute and load").

This way the "Drop field(s)" algorithm doesn't remove any fields but you 
get the option to create a tempory layer.

Hope this helps.

Bjoern