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 is a Microsoft SQL Server site, we're not experts on JOOQ or PostGres.

1 Like