Improving psql slash usage help message

From: Hamid Akhtar <hamid(dot)akhtar(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Improving psql slash usage help message
Date: 2020-04-25 19:29:11
Message-ID: CANugjhsen=5+BoxaRQm6iXd=HUhDE+FcggozR6T5_pnzbkTf2A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

psql slash usage show two options for listing foreign tables.

\dE[S+] [PATTERN] list foreign tables
\det[+] [PATTERN] list foreign tables

This seems a little odd especially when the output of both of these
commands is different.

postgres=# \dE+
List of relations
Schema | Name | Type | Owner
--------+------+---------------+--------
public | foo | foreign table | highgo
(1 row)

postgres=# \det
List of foreign tables
Schema | Table | Server
--------+-------+---------
public | foo | orc_srv
(1 row)

"\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.

Regards.

--
Highgo Software (Canada/China/Pakistan)
URL : www.highgo.ca
ADDR: 10318 WHALLEY BLVD, Surrey, BC
CELL:+923335449950 EMAIL: mailto:hamid(dot)akhtar(at)highgo(dot)ca
SKYPE: engineeredvirus

Attachment Content-Type Size
psql_help_dE.patch application/octet-stream 807 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David G. Johnston 2020-04-25 20:03:30 Re: Improving psql slash usage help message
Previous Message Dmitry Dolgov 2020-04-25 19:19:35 Re: WIP: WAL prefetch (another approach)