Postgres Pro
Downloads
Home   >   mailing lists

Metadata/ODBC query - Mailing list pgsql-general

From jerry.evans@chordia
Subject Metadata/ODBC query
Date
Msg-id 037401c87094$142b9390$0565a8c0@p424
Whole thread Raw
Responses Re: Metadata/ODBC query
List pgsql-general
Tree view
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() simply returns SQL_NO_DATA_FOUND. Both ODBC test apps work fine when accessing the same server/database running queries such as "SELECT table_name FROM INFORMATION_SCHEMA.TABLES WHERE table_type = 'BASE TABLE'"
 
I'm using the latest psqlODBC Windows installer from the web site. The driver is set to show system tables ...
 
Any clues?
 
Thanks.
 
Jerry.

pgsql-general by date:

Previous
From: Greg Smith
Date:
Subject: Re: Are indexes blown?
Next
From: Tom Lane
Date:
Subject: Re: Metadata/ODBC query