Re: Improving psql slash usage help message - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Improving psql slash usage help message
Date
Msg-id CAKFQuwac8=p_MQg74sHUecyLHqB0u2+Sf7g1J2qDuob+dBrKOQ@mail.gmail.com
Whole thread Raw
In response to Improving psql slash usage help message  (Hamid Akhtar <hamid.akhtar@gmail.com>)
Responses Re: Improving psql slash usage help message
List pgsql-hackers
On Sat, Apr 25, 2020 at 12:29 PM Hamid Akhtar <hamid.akhtar@gmail.com> wrote:

"\dE" displays the list with a "List of relations" heading whereas "\det" displays "List of foreign tables". So, to differentiate the two, I suggest to change the help message for "\dE" to:

  \dE[S+] [PATTERN]      list foreign relations

One could argue that both essentially mean the same thing, however, considering "\dE+" also outputs size, it makes sense IMHO to make this change (as PG documentation: relation is essentially a mathematical term for table). Attached is the patch that makes this change.

help.c and the documentation need to be synchronized a bit more than this single issue.

Calling it "foreign relation" for \dE and "foreign table" for \det does convey that there is a difference - not sure it a huge improvement though.  The "\d[Eimstv]" family of meta-commands should, in the help, probably be moved together to show the fact that they are basically "list relation names [of this type only]" while "\det" is "list foreign table info".

David J.

pgsql-hackers by date:

Previous
From: Hamid Akhtar
Date:
Subject: Improving psql slash usage help message
Next
From: David Rowley
Date:
Subject: Re: Binary search in ScalarArrayOpExpr for OR'd constant arrays