Skip to content
Advertisement

JOOQ materialized views

is it possible to create materialized views using the JOOQ builder? Something like this

DSL.createMaterializedView().execute()

Advertisement

Answer

In jOOQ 3.14, not yet: https://github.com/jOOQ/jOOQ/issues/9483

But you can use plain SQL templating to work around this limitation, to at least get some type safety in your statement:

ctx.execute("create materialized view view_name as {0}", select);
User contributions licensed under: CC BY-SA
5 People found this is helpful
Advertisement