Re: SQLTables does not retrieve everything

From: Clemens Ladisch <clemens(at)ladisch(dot)de>
To: pgsql-odbc(at)lists(dot)postgresql(dot)org
Subject: Re: SQLTables does not retrieve everything
Date: 2018-12-02 09:30:09
Message-ID: 9f28f9ae-b412-9484-453f-6de676b64986@ladisch.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Igor Korot 2018-12-24 01:18:35 Re: NOTIFY/LISTEN with ODBC interface
Previous Message Igor Korot 2018-12-02 06:58:45 Re: SQLTables does not retrieve everything