Re: SQLTables does not retrieve everything
Igor Korot <[email protected]> Sun, 2 Dec 2018 00:58:45 -0600
| Newsgroups | gmane.comp.db.postgresql.odbc |
|---|---|
| Message-ID | <CA+FnnTxF-GYQDaeT7GzhLg8Ba2OmH+B=BtyKidK-4WyjmDzWhA@mail.gmail.com> |
Hi, Clemens, Igor Korot wrote: >> ret = SQLTables( m_hstmt, NULL, 0, NULL, 0, NULL, 0, NULL, 0 ); >> >> 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. > >System tables are hidden by default, unless you specify them explicitly >in the TableType parameter. > >The "Show System Tables" data source configuration option can change >this behaviour. I presume I should add: ShowSystemTable = true to odbc.ini. Am I right? Or that needs to be spaced out? On the un-related note, I didn't receive you reply to the list. Could you please check my subscription to the list? Thank you. Regards, Clemens