Comment Comment by Sharlin A nifty thing we use in our current project is the ltree extension[1]. It allows representing hierarchical relations and making hierarchical queries in a regular flat table structure.[1] https://www.postgresql.org/docs/10/static/ltree.html parent Sharlin 8 years ago
[1] https://www.postgresql.org/docs/10/static/ltree.html