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
psql_help_dE.patch
Description: Binary data