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 <[email protected]> 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 > [email protected] > List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
_______________________________________________ QGIS-Developer mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
