Available in versions: Dev (3.18) | Latest (3.17) | 3.16 | 3.15


Applies to ✅ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

The jooq-postgres-extensions module contains data types, converters, and bindings for the following data types:

  • hstore represents a key-value store (i.e. a Map<String, String>)

In order to access these data types, just add the following dependency to your project:

    <!-- Use org.jooq                for the Open Source Edition
             org.jooq.pro            for commercial editions with Java 17 support, 
             org.jooq.pro-java-11    for commercial editions with Java 11 support,
             org.jooq.pro-java-8     for commercial editions with Java 8 support,
             org.jooq.trial          for the free trial edition with Java 17 support, 
             org.jooq.trial-java-11  for the free trial edition with Java 11 support, 
             org.jooq.trial-java-8   for the free trial edition with Java 8 support 
         Note: Only the Open Source Edition is hosted on Maven Central. 
               Import the others manually from your distribution -->

The data type extensions can be added as forced types like this:

XML (standalone and maven)
<configuration xmlns="http://www.jooq.org/xsd/jooq-codegen-3.16.0.xsd">
new org.jooq.meta.jaxb.Configuration()
  .withGenerator(new Generator()
    .withDatabase(new Database()
        new ForcedType()
myConfigurationName(sourceSets.main) {
  generator {
    database {
      forcedTypes {
        forcedType {
          userType = 'org.jooq.postgres.extensions.types.Hstore'
          binding = 'org.jooq.postgres.extensions.bindings.HstoreBinding'
          includeTypes = 'hstore'


Do you have any feedback about this page? We'd love to hear it!

The jOOQ Logo