Re: Metadata/ODBC query - Mailing list pgsql-general

From Tom Lane
Subject Re: Metadata/ODBC query
Date
Msg-id 17622.1203172027@sss.pgh.pa.us
Whole thread Raw
In response to Re: Metadata/ODBC query  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I wrote:
> What userid are you connecting as under ODBC?  Has it got privileges to
> any of the schemas?  The information_schema views generally hide objects
> that you have no privileges for ...

In fact, looking closer, it looks like the schemata view only shows you
schemas that you are the *owner* of (as is required by spec).  So a
superuser would see everything but ordinary users might well not see
anything.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Metadata/ODBC query
Next
From: "Phoenix Kiula"
Date:
Subject: Timestamp indexes (why ">" or "between" does not use index?)