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

At Mon, 2 Aug 2021 22:28:33 -0700, "David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> wrote in
> On Mon, Aug 2, 2021 at 9:35 PM Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>
> wrote:
>
> > > Note
> > > If \d is used without a pattern argument, it is equivalent to \dtvmsE
> > > which will show a list of all visible tables, views, materialized
> > ~~~~~~~
> > > views, sequences and foreign tables. This is purely a convenience
> > > measure.
> >
> > However, I don't think the "visible" works as expected for ordinary
> > users.
> >
>
> I cannot see rewording this to avoid the use of "visible", but if this is a

Year, I think "visible" is the best word there. And I'm not sure
people are actually confused about the word.

> concern worth addressing I suggest weaving in a link to section 5.9.3
>
> https://www.postgresql.org/docs/current/ddl-schemas.html#DDL-SCHEMAS-PATH
>
> But I will note that if someone follows such a link the section is not
> written all that well to address this usage of "visibility". I didn't look
> to see if there is a better place to link to.

Maybe somethink ike thid would work?

| If \d is used without a pattern argument, it is equivalent to \dtvmsE
| which will show a list of all visible tables, views, materialized
| views, sequences and foreign tables. This is purely a convenience
| measure.
+ Objects with the same name of the same kind in different schema may
+ hide each other according to the search-path setting. See
+ <DDL-SCHEMAS-PATH> for details.

It could be shorter and smarter, though.

regards.

--
Kyotaro Horiguchi
NTT Open Source Software Center