From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com> |
Cc: | david(dot)g(dot)johnston(at)gmail(dot)com, wstrzalka(at)gmail(dot)com, pavel(dot)stehule(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: psql doesn't show tables duplicated in multiple schemas |
Date: | 2021-08-03 13:47:41 |
Message-ID: | 1703093.1627998461@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com> writes:
> At Mon, 2 Aug 2021 22:28:33 -0700, "David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2021-08-03 13:52:05 | Re: BUG #17130: Error while executing request |
Previous Message | Guillaume Lelarge | 2021-08-03 13:26:03 | Re: BUG #17130: Error while executing request |