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

At Mon, 2 Aug 2021 22:28:33 -0700, "David G. Johnston" <david.g.johnston@gmail.com> wrote in 
> On Mon, Aug 2, 2021 at 9:35 PM Kyotaro Horiguchi <horikyota.ntt@gmail.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