PostgreSQL HSTORE type
Supported by ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
The HSTORE type stores a key value store of the form key1 => value1, key2 => value2. jOOQ offers support for this type via a org.jooq.postgres.extensions.types.Hstore type that exposes the data structure in form of a Map<String, String>
Hstore store = create.fetchValue(T.HSTORE, T.ID.eq(id)); Map<String, String> value = store.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!