... I might as well read the manual ;-) http://www.postgresql.org/docs/9.1/static/infoschema-schemata.html http://www.postgresql.org/docs/9.1/static/infoschema-tables.html
Cheers Lukas 2012/5/9 Lukas Eder <[email protected]>: > 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!
