Re: BUG #5180: How to get only User created tables by using SQLTables() in ODBC - Mailing list 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);

Regards,
Nikhils
--
http://www.enterprisedb.com