It doesn't work. information_schema.tables does not contain any information about postgresql materialized views, at least currently: http://postgresql.1045698.n5.nabble.com/Re-Materialized-views-WIP-patch-td5740513i40.html
See also: http://stackoverflow.com/questions/19127561/how-to-introspect-materialized-views Since this doesn't work (and probably won't anytime soon), I'm looking for the right way to create a select statement that includes a sub-query on a materialized view joined with another table. Since I can't access the materialized view directly via jOOQ, I can write the sub-query in pure SQL. I can also run the sub-query and pass the results of it to the jOOQ query. But is there a way to use the Jooq DSL to hook up a plain-SQL query to the in() clause of a Jooq query so that Jooq can execute it all in one db call? Regards, Raman On Wednesday, May 7, 2014 12:26:51 PM UTC-4, Lukas Eder wrote: > > Normally, it should be, although, if materialized views are not reported > from information_schema.tables, then jOOQ currently isn't aware of them. > > Have you tried? > > > 2014-05-07 17:54 GMT+02:00 Raman Gupta <[email protected] <javascript:>>: > >> Is it possible to have Jooq generate code for Postgresql materialized >> views? >> >> Regards, >> Raman >> >> -- >> You received this message because you are subscribed to the Google Groups >> "jOOQ User Group" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
