Quick Links

Re: BUG #5180: How to get only User created tables by using SQLTables() in ODBC

From:	Nikhil Sontakke <nikhil(dot)sontakke(at)enterprisedb(dot)com>
To:	Jitendra Lenka <jitendra(dot)lenka(at)csqldb(dot)com>
Cc:	pgsql-bugs(at)postgresql(dot)org
Subject:	Re: BUG #5180: How to get only User created tables by using SQLTables() in ODBC
Date:	2009-11-23 12:58:45
Message-ID:	a301bfd90911230458k1a3fb859i929d77d8185e48da@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-bugs

Hi,

> Please find the code:
> --------------------
> retValue=SQLTables(hstmt, NULL, 0, NULL, 0, NULL, 0, (SQLCHAR*) "TABLE",
> SQL_NTS);
>

You should pass the schemaname to the above call to restrict the
result set to a specific schema. For example:

SQLTables(hstmt, NULL, 0, (SQLCHAR *)"public", SQL_NTS, NULL, 0,
(SQLCHAR*) "TABLE", SQL_NTS);

	From	Date	Subject
Next Message	Robert Haas	2009-11-23 22:11:49	Re: BUG #5206: wal_sync_method in stock postgresql.conf may be wrong
Previous Message	Heikki Linnakangas	2009-11-23 10:10:09	Re: Multixact and prepared transactions