PostGIS Cookbook - Second Edition

How it works...

PostgreSQL table inheritance allows us to enforce essentially hierarchical relationships between tables. In this case, we leverage inheritance to allow for commonality between related datasets. Now, if we want to query data from these tables, we can query directly from the parent table as follows, depending on whether we want a mix of geometries or just a targeted dataset:

SELECT * FROM chp02.hydrology 

From any of the child tables, we could use the following query:

SELECT * FROM chp02.hydrology_polygon