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.akh...@highgo.ca
SKYPE: engineeredvirus

Attachment: psql_help_dE.patch
Description: Binary data

Reply via email to