[QGIS-Developer] SQL in graphic modeller - Reg

[Karthikeyan M]

Hi Alexandre,

Thank you for your reply. It worked for me.

Thanks and Regards,
Karthikeyan M

On Fri, Aug 14, 2020 at 6:56 PM Alexandre Neto <senhor.neto at gmail.com>
wrote:

> 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/20200818/cfb2327c/attachment.html>