SQLTables does not retrieve everything

Igor Korot <[email protected]> Fri, 30 Nov 2018 00:12:44 -0600
Newsgroups gmane.comp.db.postgresql.odbc
Message-ID <CA+FnnTyitv9THB8MkLw4rN5BJPx3QFzSNqOtr4GtBbJd6y_RfQ@mail.gmail.com>
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.