On Tue, Oct 20, 2015 at 7:35 AM, Piotr Kania <p.ka...@op.pl> wrote: > In my postgis database I have multipolygon layer 'public.polygons' > (gid,geom), I'd like to see vertices of those layer during editing, that's > why I thought of postgis view. I create that in database: > > CREATE VIEW points_of_polygons AS SELECT ST_DumpPoints(geom) AS geom FROM > public.polygons; > > But I can't add that view to Qgis, I found that info: >
Views are not selectable from the Add PostGIS icon. But starting in version 2.10 you can add the view points_of_polygons by using the DB Manager. A unique id is no longer required. If you are using an earlier version then you'll need to create a unique row number. The stackexchange link you provided gives an example of using ROWNUMBER() OVER() to create the unique id. -- @osm_seattle osm_seattle.snowandsnow.us OpenStreetMap: Maps with a human touch
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
