Re: Re: [COMMITTERS] pgsql: This makes all the \dX commands (most importantly to most: \df) - Mailing list pgsql-hackers

Joshua D. Drake wrote:
> On Tue, 2009-01-06 at 18:08 -0500, Bruce Momjian wrote:
> > Bruce Momjian wrote:
> 
> > > I also found a bug that \do didn't work because the AND system table
> > > check was being added to the LEFT JOIN and not to the WHERE clause
> > > (trigger display was also a problem).
> > 
> > Let me also say that that \d* display is ready to fall over from its own
> > weight:
> > 
> >     Informational
> >       Modifiers: S = show system objects  + = Additional detail
> >       \l[+]                list all databases
> >       \d[S+]               list tables, views, and sequences
> >       \d[S+] NAME          describe table, view, sequence, or index
> >       \da[S] [PATTERN]     list aggregate functions
> >       \db[+] [PATTERN]     list tablespaces
> >       \dc[S] [PATTERN]     list conversions
> 
> Hmmm, I wonder if it makes sense to make it four column instead of two
> column.

You mean like this?
   fprintf(output, _("Informational\n"));   fprintf(output, _("  Modifiers: S = show system objects  + = Additional
detail\n"));  fprintf(output, _("  \\l[+]                list all databases\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 aggregate functions\n"));   fprintf(output,
_(" \\db[+]   [PATTERN]   list tablespaces\n"));   fprintf(output, _("  \\dc[S]   [PATTERN]   list conversions\n"));
fprintf(output,_("  \\dC      [PATTERN]   list casts\n"));   fprintf(output, _("  \\dd      [PATTERN]   show comment
forobject\n"));   fprintf(output, _("  \\dd[S]   [PATTERN]   list comments on objects\n"));   fprintf(output, _("
\\dD[S]  [PATTERN]   list domains\n"));   fprintf(output, _("  \\des[+]  [PATTERN]   list foreign servers\n"));
fprintf(output,_("  \\deu[+]  [PATTERN]   list user mappings\n"));   fprintf(output, _("  \\dew[+]  [PATTERN]   list
foreign-datawrappers\n"));   fprintf(output, _("  \\df[S+]  [PATTERN]   list functions\n"));   fprintf(output, _("
\\dF[+]  [PATTERN]   list text search configurations\n"));   fprintf(output, _("  \\dFd[+]  [PATTERN]   list text
searchdictionaries\n"));   fprintf(output, _("  \\dFp[+]  [PATTERN]   list text search parsers\n"));   fprintf(output,
_(" \\dFt[+]  [PATTERN]   list text search templates\n"));   fprintf(output, _("  \\dg      [PATTERN]   list roles
(groups)\n"));  fprintf(output, _("  \\di[S+]  [PATTERN]   list indexes\n"));   fprintf(output, _("  \\dl
  list large objects, same as \\lo_list\n"));   fprintf(output, _("  \\dn[+]   [PATTERN]   list schemas\n"));
fprintf(output,_("  \\do[S]   [PATTERN]   list operators\n"));   fprintf(output, _("  \\dp      [PATTERN]   list table,
view,and sequence access privileges\n"));   fprintf(output, _("   \\z      [PATTERN]   same as \\dp\n"));
fprintf(output,_("  \\ds[S+]  [PATTERN]   list sequences\n"));   fprintf(output, _("  \\dt[S+]  [PATTERN]   list
tables\n"));  fprintf(output, _("  \\dT[S+]  [PATTERN]   list data types\n"));   fprintf(output, _("  \\du
[PATTERN]  list roles (users)\n"));   fprintf(output, _("  \\dv[S+]  [PATTERN]   list views\n"));   fprintf(output,
"\n");

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +