On 10/15/22 08:20, Adrian Klaver wrote:
> On 10/14/22 21:46, Igor Korot wrote:
>
>
>> Making catalog current means switching between DBs.
>> Remember initially I connected to (finance) DB, which made the
>> (finance) catalog
>> current.
>> Then I "opened a second connection" to (finance_2021), which made
>> that current catalog and so that select would give me all tables from
>> (finance_2021).
>
> No you didn't.
>
> Rough outline of what happens:
>
> 1) You connected to the database finance.
> 2) While in the finance database you queried the foreign tables that are
> linked to finance_2021.
> 3) The queries made connections the to finance_2021 for the purposes of
> making the data visible in the foreign tables in finance.
> 4) The client you did this did not 'leave' the finance database, so the
^
in
> only information_schema you have access to is in the finance database.
>
>>
>> I hope now its clearer.
>>
>> Thank you.
>>
>>>
>>> David J.
>>
>>
>
--
Adrian Klaver
adrian.klaver@aklaver.com