psql \? \daS

Started by Stephen Frostover 15 years ago2 messages
#1Stephen Frost
sfrost@snowman.net

Greetings,

Noticed this while playing around with psql regression tests.

Thanks,

Stephen

commit 31bf61bab77ad991f2a67a41699384e57c021508
Author: Stephen Frost <sfrost@snowman.net>
Date: Wed May 26 13:51:27 2010 -0400

Add 'S' to optional parameters for \da

\da supports \daS, \da+ and \daS+. This updates psql's \? help
screen to include the 'S'. Missed during the addition of S as
an option for most \d commands to list System objects.

diff --git a/src/bin/psql/help.c b/src/bin/psql/help.c
index f129041..600ef82 100644
*** a/src/bin/psql/help.c
--- b/src/bin/psql/help.c
*************** slashUsage(unsigned short int pager)
*** 196,202 ****
  	fprintf(output, _("  (options: S = show system objects, + = additional detail)\n"));
  	fprintf(output, _("  \\d[S+]                 list tables, views, and sequences\n"));
  	fprintf(output, _("  \\d[S+]  NAME           describe table, view, sequence, or index\n"));
! 	fprintf(output, _("  \\da[+]  [PATTERN]      list aggregates\n"));
  	fprintf(output, _("  \\db[+]  [PATTERN]      list tablespaces\n"));
  	fprintf(output, _("  \\dc[S]  [PATTERN]      list conversions\n"));
  	fprintf(output, _("  \\dC     [PATTERN]      list casts\n"));
--- 196,202 ----
  	fprintf(output, _("  (options: S = show system objects, + = additional detail)\n"));
  	fprintf(output, _("  \\d[S+]                 list tables, views, and sequences\n"));
  	fprintf(output, _("  \\d[S+]  NAME           describe table, view, sequence, or index\n"));
! 	fprintf(output, _("  \\da[S+] [PATTERN]      list aggregates\n"));
  	fprintf(output, _("  \\db[+]  [PATTERN]      list tablespaces\n"));
  	fprintf(output, _("  \\dc[S]  [PATTERN]      list conversions\n"));
  	fprintf(output, _("  \\dC     [PATTERN]      list casts\n"));
#2Robert Haas
robertmhaas@gmail.com
In reply to: Stephen Frost (#1)
Re: psql \? \daS

On Wed, May 26, 2010 at 1:59 PM, Stephen Frost <sfrost@snowman.net> wrote:

 Noticed this while playing around with psql regression tests.

Good catch. It looks like the + option doesn't actually do anything
for \da, though, so I'm inclined to just write \da[S] rather than
\da[S+] (see: \dl, \dC).

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company