Yes thank you! I do look forward to filterSchema though.
On Friday, October 16, 2020 at 1:37:53 AM UTC-7 [email protected] wrote:
> 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/aca3a266-2bcb-445e-8108-f1d53adc06cdn%40googlegroups.com.
