[Qgis-user] load data in Qgis by a query on geom column

[Wolf-E. Altmann]

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
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
Hi Pietro,

by using the plugin db-manager it is possible.

Wolf