psql \? \daS
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"));
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