Postgre View


```typeselect * from pg_views```


```typecreate view test_line as select id, jsb, geom::geometry(LineString, 4326)from testwhere geometryType(geom) = 'LINESTRING';```


### qgis editable view
> [Error editing 'editable' view in QGIS](https://gis.stackexchange.com/questions/201181/error-editing-editable-view-in-qgis)

> [How to render mixed geometry from one table?](https://gis.stackexchange.com/questions/194503/how-to-render-mixed-geometry-from-one-table)






