[postgis-users] (no subject)

[celati Laurent]

Good morning,

I have 5 postgis tables which have different types of geometries (1 point,
1 linear, 3 polygon). And also different field structures. These tables
share fields that provide the same information (project_monitoring,
municipality, etc.). Although the name of these fields is not always
identical according to the tables.

I would like to be able to create a view that can retrieve a few fields
from these tables: the geom, the values of municipalities, the
monitoring_scope  Do you know how I can do?

Thanks a lot.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20230823/54d03617/attachment.htm>