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-11-30 07:13:42
Message-ID: c8dcdf56-f36a-a882-8eeb-6f06c4d919a7@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.

The "Show System Tables" data source configuration option can change
this behaviour.

Regards,
Clemens

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Igor Korot 2018-12-01 19:16:21 Re: SQLTables does not retrieve everything
Previous Message Igor Korot 2018-11-30 06:13:51 Re: SQLTables does not retrieve everything