Hello, Thank you very much for your feedback.
There's currently no out of the box support for index meta information queries in jOOQ. I have added a feature request for this. It certainly makes sense to add such support to jOOQ: https://github.com/jOOQ/jOOQ/issues/5181 In the meantime, you will have to resort to using JDBC's DatabaseMetaData. You can easily fetch information via jOOQ as such: ctx.connection(connection -> { System.out.println(ctx.fetch(connection.getMetaData().getIndexInfo(...))); }); Hope this helps, Lukas 2016-03-31 17:26 GMT+02:00 <[email protected]>: > > I'm using JOOQ with H2. > > Within H2 Console I can see a list of Indexes > > > <https://lh3.googleusercontent.com/-eV1icuH_98M/Vv07EPA0KJI/AAAAAAAAAAM/7JQbc2nKjW0fb0zDDxBMeO3d9pSXIrPaw/s1600/ProjectIndexes.jpg> > > > > > > > > > > > > > > > And in H2 docs > <https://javadocs.com/docs/com.h2database/h2/1.2.145/org/h2/table/MetaTable.java#getIndexes%28%29> > how to getIndexes(), but is there a JOOQ interface which supports this? > > As far as I can see on Table reference > <http://www.jooq.org/javadoc/latest/> I can only get Primary, Foreign or > Unique Keys - none of these give access to the "INDEX_18" (GROUP_ID, NAME) > event when it's marked Unique ?! > > > -- > 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. > -- 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.
