Does JOOQ support creating PostgreSQL index with varchar_pattern_ops option?
I want to upgrade my PostgreSQL DB schema using a migrator running in Java and I’m using JOOQ for generating Java files for my project. Currently, to upgrade my DB schema I must drop the old index and replace it with an explicit SQL query including varchar_pattern_ops aka
How to use postgres json column in where clause with jooq
I have a postgres database table where one of the many columns is defined as