Comment by somebee

The ltree extension (https://www.postgresql.org/docs/current/ltree.html) is perfect for this usecase.