Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Metadata/ODBC query
Date
Msg-id 17452.1203171683@sss.pgh.pa.us
Whole thread Raw
In response to Metadata/ODBC query  ("jerry.evans@chordia" <jerry.evans@chordia.co.uk>)
Responses Re: Metadata/ODBC query
List pgsql-general
Tree view 
"jerry.evans@chordia" <jerry.evans@chordia.co.uk> writes:
> If I use pgAdmin and run "SELECT catalog_name FROM Information_Schema.Schemata" I get data back as expected.

> If I connect via ODBC and issue the same query I don't see any data.

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 ...

            regards, tom lane

pgsql-general by date:

Previous
From: "jerry.evans@chordia"
Date:
Subject: Metadata/ODBC query
Next
From: Tom Lane
Date:
Subject: Re: Metadata/ODBC query