Re: psql doesn't show tables duplicated in multiple schemas

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Wojciech Strzalka <wstrzalka(at)gmail(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: psql doesn't show tables duplicated in multiple schemas
Date: 2021-08-02 10:42:08
Message-ID: 20210802104208.GA9634@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Aug 02, 2021 at 09:05:19AM +0200, Wojciech Strzalka wrote:
> I would expect last table listing to include 'y.b' table. Although shadowed
> when referencing by 'b' it's still there.

Not really a bug. It shows you "visible" tables, that is - tables that
you can reach without specifying schema.

If you want to find all tables "b" across all schema, do:

#v+
\dt *.b
#v-

Best regards,

depesz

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Wojciech Strzalka 2021-08-02 10:57:17 Re: psql doesn't show tables duplicated in multiple schemas
Previous Message Pavel Stehule 2021-08-02 09:32:16 Re: psql doesn't show tables duplicated in multiple schemas