[HACKERS] psql \? \daS

2010-05-26 Thread Stephen Frost
Greetings,

  Noticed this while playing around with psql regression tests.

Thanks,

Stephen

commit 31bf61bab77ad991f2a67a41699384e57c021508
Author: Stephen Frost sfr...@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));


signature.asc
Description: Digital signature


Re: [HACKERS] psql \? \daS

2010-05-26 Thread Robert Haas
On Wed, May 26, 2010 at 1:59 PM, Stephen Frost sfr...@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

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers