[QGIS-Developer] SQL in graphic modeller - Reg

[Alexandre Neto]

Hello,

Have you tried to use the PostgreSQL execute and load algorithm from the
Processing toolbox?

https://docs.qgis.org/testing/en/docs/user_manual/processing_algs/qgis/database.html#postgresql-execute-and-load-sql

Another alternative is to use the Refactor fields tool, where you can
select the columns you want to keep and in which order.

https://docs.qgis.org/testing/en/docs/user_manual/processing_algs/qgis/vectortable.html#refactor-fields

Best regards,

Alexandre Neto
QGIS Support
www.qcooperative.net

A sexta, 14/08/2020, 12:23, Karthikeyan M <kalam1993 at gmail.com> escreveu:

> Hi ,
>
> I'm learning graphic modeller in QGis3. Earlier I used to select only 3
> columns ( from 73 coloumn) of attributes by using sql query in DB manager.
> I want to create a  model for that. Is there anyway I can use that sql
> query to extract particular coloumn from shape files using Graphic modeller
> ?
>
> Expecting your reply
>
> Regards,
> Karthikeyan M
>
>
> _______________________________________________
> QGIS-Developer mailing list
> QGIS-Developer at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20200814/01b45c58/attachment.html>