Re: SQLTables does not retrieve everything

Clemens Ladisch <[email protected]> Sun, 2 Dec 2018 10:30:09 +0100

Newsgroups	gmane.comp.db.postgresql.odbc
Message-ID	<[email protected]>

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.

E.g.:

  const char *all_types = "SYSTEM TABLE,TABLE,VIEW,FOREIGN TABLE,MATVIEW";
  SQLTables(..., all_types, strlen(all_types));


Regards,
Clemens