SQLTables does not retrieve everything
| От | Igor Korot |
|---|---|
| Тема | SQLTables does not retrieve everything |
| Дата | |
| Msg-id | CA+FnnTyitv9THB8MkLw4rN5BJPx3QFzSNqOtr4GtBbJd6y_RfQ@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: SQLTables does not retrieve everything
Re: SQLTables does not retrieve everything |
| Список | pgsql-odbc |
Hi,
I am trying to write an application where I need to know the list of
"ALL" tables and views.
However, it looks like the code:
[code]
ret = SQLTables( m_hstmt, NULL, 0, NULL, 0, NULL, 0, NULL, 0 );
if( ret != SQL_SUCCESS && ret != SQL_SUCCESS_WITH_INFO )
{
GetErrorMessage( errorMsg, 1 );
result = 1;
}
[/code]
only retrieves the tables from the current database/catalog and "public" schema.
There is no tables/view on the INFORMATION_SCHEMA and all the system tables.
Do I have to drop it and use the actual query for that?
Because in MS SQL that code retrieves everything...
I am currently testing with PG9.1 on OSX 10.8 with Xcode 5.
Thank you for any pointers.
В списке pgsql-odbc по дате отправления: