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

[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.