Hmm, I tested this now with a new test user, trying to query the public schema. information_schema.tables doesn't return any tables then. Is that due to missing grants? So in short:
- information_schema.schemata displays objects of which CURRENT_USER is the owner - information_schema.tables displays objects to which CURRENT_USER has grants Is that correct? 2012/5/9 Sander Plas <[email protected]>: > On Wednesday, May 9, 2012 10:04:30 PM UTC+2, Lukas Eder wrote: >> >> Great, thanks for investigating. I'll schedule a release 2.3.1 for >> this weekend. It'll include #1409 fixing this. >> https://sourceforge.net/apps/trac/jooq/ticket/1409 >> >> A SNAPSHOT will be available earlier. >> > Thanks Lukas!
