Postgre View

Creator

Creator

Seonglae Cho

Created

Created

2020 Dec 8 8:35

Editor

Editor

Seonglae Cho

Edited

Edited

2025 Oct 9 16:48

Refs

Refs


select * from pg_views


create view test_line as select id, jsb, geom::geometry(LineString, 4326)
from test
where geometryType(geom) = 'LINESTRING';

qgis editable view

Error editing 'editable' view in QGIS

Taking some code from this post, I've been trying to create an 'editable' view in PostGIS. I'd like to store label placement properties in a separate table, build a view of the data I want to use for my map, and use QGIS to move the labels.

https://gis.stackexchange.com/questions/201181/error-editing-editable-view-in-qgis

How to render mixed geometry from one table?

Thanks for contributing an answer to Geographic Information Systems Stack Exchange! Please be sure to answer the question. Provide details and share your research! Asking for help, clarification, or responding to other answers. Making statements based on opinion; back them up with references or personal experience.

https://gis.stackexchange.com/questions/194503/how-to-render-mixed-geometry-from-one-table

Backlinks

Postgres Structure

Recommendations

////////