Hi Megan,
Thanks for your message. You can iterate the results and query them from
there, such as:
for (Catalog catalog : meta().getCatalogs())
if (catalog.getName().equals("database_name"))
for (Schema schema : catalog.getSchemas())
if (schema.getName().equals("schema_name"))
for (Table<?> table : schema.getTables())
doSomething(table);
Starting from jOOQ 3.14, there will also be Meta.filterSchemas() and
similar methods to allow for filtering schemas for the entire scope of a
Meta reference:
https://www.jooq.org/javadoc/3.14.x/org.jooq/org/jooq/Meta.html#filterSchemas(org.jooq.Meta.Predicate)
I hope this helps,
Lukas
On Thu, Oct 15, 2020 at 11:15 PM Megan A <[email protected]> wrote:
>
> Hi,
>
> It looks like meta() scans all catalogs and all schemas on every call.
> I'd really like to to only scan one schema. As I don't control the other
> schemas and it can become a slow query when an unrelated database has lots
> of tables. Is there a way to say "Only grab metadata from this one schema"?
> Better yet, "Only grab the metadata for this one table" would be even
> better.
>
> Thanks,
>
> Megan
>
> --
> 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].
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/jooq-user/278a4d71-bedb-4862-b89e-17407db9da37n%40googlegroups.com
> <https://groups.google.com/d/msgid/jooq-user/278a4d71-bedb-4862-b89e-17407db9da37n%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>
--
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].
To view this discussion on the web visit
https://groups.google.com/d/msgid/jooq-user/CAB4ELO4vC3u9nqRPT2xvDn5CFKTAChrQwJQ_jYvyT%2BWEn3QyyA%40mail.gmail.com.
