Re: [GENERAL] Metadata/ODBC query

2008-02-16 Thread Tom Lane
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 *owne

Re: [GENERAL] Metadata/ODBC query

2008-02-16 Thread Tom Lane
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> 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 privil

[GENERAL] Metadata/ODBC query

2008-02-16 Thread [EMAIL PROTECTED]
Hi I'm experimenting with PostgreSQL 8.3.0 on Windows connecting via ODBC. One curiosity so far is this: 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. SQLFetch()