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 |
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) |