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

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема Re: psql doesn't show tables duplicated in multiple schemas
Дата
Msg-id 20210802104208.GA9634@depesz.com
обсуждение исходный текст
Ответ на psql doesn't show tables duplicated in multiple schemas  (Wojciech Strzalka <wstrzalka@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: psql doesn't show tables duplicated in multiple schemas
Следующее
От: Wojciech Strzalka
Дата:
Сообщение: Re: psql doesn't show tables duplicated in multiple schemas