From: Tom Lane <tgl@sss.pgh.pa.us>
To: Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Cc: david.g.johnston@gmail.com
Cc: wstrzalka@gmail.com
Cc: pavel.stehule@gmail.com
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: psql doesn't show tables duplicated in multiple schemas
Date: Tue, 03 Aug 2021 09:47:41 -0400
Message-ID: <1703093.1627998461@sss.pgh.pa.us> (raw)
In-Reply-To: <20210803.151652.174400284784013194.horikyota.ntt@gmail.com>
References: <CAJf-CGtMRx==A=BOcgj03jE4gem_0yan81y2soLCGbeB828+2w@mail.gmail.com>
<20210803.133502.2007206546027287879.horikyota.ntt@gmail.com>
<CAKFQuwZZz+iJuA4SgdbkqFq3po8NmcVWubw-zhR9WDuMqP-WGw@mail.gmail.com>
<20210803.151652.174400284784013194.horikyota.ntt@gmail.com>
Kyotaro Horiguchi <horikyota.ntt@gmail.com> writes:
> At Mon, 2 Aug 2021 22:28:33 -0700, "David G. Johnston" <david.g.johnston@gmail.com> wrote in
>> 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.
The term is actually defined in the psql ref page, in the second para
of the "Patterns" section:
<para>
Whenever the <replaceable class="parameter">pattern</replaceable> parameter
is omitted completely, the <literal>\d</literal> commands display all objects
that are visible in the current schema search path — this is
equivalent to using <literal>*</literal> as the pattern.
(An object is said to be <firstterm>visible</firstterm> if its
containing schema is in the search path and no object of the same
kind and name appears earlier in the search path. This is equivalent to the
statement that the object can be referenced by name without explicit
schema qualification.)
To see all objects in the database regardless of visibility,
use <literal>*.*</literal> as the pattern.
</para>
Maybe this could be rearranged to make the concept more prominent,
but I'm not convinced that we need any really new text. I definitely
don't want to make duplicative additions to each \d command's text.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, horikyota.ntt@gmail.com, david.g.johnston@gmail.com, wstrzalka@gmail.com, pavel.stehule@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: psql doesn't show tables duplicated in multiple schemas
In-Reply-To: <1703093.1627998461@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox