Am 25.10.2012 12:16, schrieb Pietro Rossin:
Is it possible to load data in qgis from postgis by a query on the geometry column?If for example I'll like to load data between Xmin adn Xmax in pgadmin I'll do like this: SELECT* FROM public.mytable WHERE st_xmin(the_geom) >= myXmin and st_xmax(the_geom)<= myXmax; How can I do it in qgis? (if possible..) Are these query feasable in qgis? SELECT ogc_fid, st_transform(st_makepolygon(mytable.the_geom), 3004)::geometry(PolygonZ,3004) AS the_geom, mytable.layer FROM mytable WHERE st_isclosed(mytable.the_geom) = true; -- View this message in context: http://osgeo-org.1560.n6.nabble.com/load-data-in-Qgis-by-a-query-on-geom-column-tp5011161.html Sent from the Quantum GIS - User mailing list archive at Nabble.com. _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
Hi Pietro, by using the plugin db-manager it is possible. Wolf _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
