Re: psql doesn't show tables duplicated in multiple schemas - Mailing list pgsql-bugs

From hubert depesz lubaczewski
Subject Re: psql doesn't show tables duplicated in multiple schemas
Date
Msg-id 20210802104208.GA9634@depesz.com
Whole thread Raw
In response to psql doesn't show tables duplicated in multiple schemas  (Wojciech Strzalka <wstrzalka@gmail.com>)
List 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




pgsql-bugs by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: psql doesn't show tables duplicated in multiple schemas
Next
From: Wojciech Strzalka
Date:
Subject: Re: psql doesn't show tables duplicated in multiple schemas