PostgreSQL LTREE type
Supported by ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
The LTREE type stores a set of labels in a hierarchical, tree like data structure, such as Label1.Label2.Label3, or with a more specific example, Countries.Europe.Switzerland. jOOQ offers support for this type via a org.jooq.postgres.extensions.types.Ltree type that exposes the data structure in form of a java.lang.String.
Ltree ltree = create.fetchValue(T.LTREE, T.ID.eq(id)); String value = ltree.data();
Support for this data type is included in the jooq-postgres-extensions module.
Feedback
Do you have any feedback about this page? We'd love to hear it!