Re: SQLTables does not retrieve everything
Igor Korot <[email protected]> Sat, 1 Dec 2018 13:16:21 -0600
| Newsgroups | gmane.comp.db.postgresql.odbc |
|---|---|
| Message-ID | <CA+FnnTw9N-dOfzG0PGf4ZLtpjr5Z7agYRBH-z3nU0FD7dj4Bxg@mail.gmail.com> |
Or maybe there is a way to set it using SQLSetOption()? Thank you. On Sun, Dec 2, 2018 at 12:58 AM Igor Korot <[email protected]> wrote: > > 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