<div dir="auto"><div dir="auto">Hello,</div><div dir="auto"><br></div>Have you tried to use the PostgreSQL execute and load algorithm from the Processing toolbox?<div dir="auto"><br></div><div dir="auto"><a href="https://docs.qgis.org/testing/en/docs/user_manual/processing_algs/qgis/database.html#postgresql-execute-and-load-sql">https://docs.qgis.org/testing/en/docs/user_manual/processing_algs/qgis/database.html#postgresql-execute-and-load-sql</a><br></div><div dir="auto"><br></div><div dir="auto">Another alternative is to use the Refactor fields tool, where you can select the columns you want to keep and in which order.</div><div dir="auto"><br></div><div dir="auto"><a href="https://docs.qgis.org/testing/en/docs/user_manual/processing_algs/qgis/vectortable.html#refactor-fields">https://docs.qgis.org/testing/en/docs/user_manual/processing_algs/qgis/vectortable.html#refactor-fields</a><br></div><div dir="auto"><br></div><div dir="auto">Best regards,</div><div dir="auto"><br></div><div dir="auto">Alexandre Neto</div><div dir="auto">QGIS Support</div><div dir="auto"><a href="http://www.qcooperative.net">www.qcooperative.net</a></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">A sexta, 14/08/2020, 12:23, Karthikeyan M <<a href="mailto:kalam1993@gmail.com">kalam1993@gmail.com</a>> escreveu:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi , <br><br>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 ?<br><br><div style="margin:0px;padding:0px 0px 20px;width:1368px;font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:medium"><div><div id="m_8894717614277104565gmail-:1uy" style="font-size:0.875rem;direction:ltr;margin:8px 0px 0px;padding:0px"><div id="m_8894717614277104565gmail-:1tu" style="overflow:hidden;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:small;line-height:1.5;font-family:Arial,Helvetica,sans-serif"><div dir="ltr">Expecting your reply<br><br>Regards,<br>Karthikeyan M   <div></div><div><br></div></div><div></div></div></div><div style="border-bottom-left-radius:1px;border-bottom-right-radius:1px;padding:0px;width:auto;background:rgb(242,242,242);margin:0px"></div></div></div><br></div>
_______________________________________________<br>
QGIS-Developer mailing list<br>
<a href="mailto:QGIS-Developer@lists.osgeo.org" target="_blank" rel="noreferrer">QGIS-Developer@lists.osgeo.org</a><br>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a></blockquote></div>