From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | jd(at)commandprompt(dot)com, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Re: [COMMITTERS] pgsql: This makes all the \dX commands (most importantly to most: \df) |
Date: | 2009-01-07 00:06:47 |
Message-ID: | 200901070006.n0706ls11477@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers pgsql-hackers |
Bruce Momjian wrote:
> 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.
OK, done (below). 'list' seems kind of redundant. Can we factor that
out somehow?
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
\dC [PATTERN] list casts
\dd [PATTERN] show comment for object
\dd[S] [PATTERN] list comments on objects
\dD[S] [PATTERN] list domains
\des[+] [PATTERN] list foreign servers
\deu[+] [PATTERN] list user mappings
\dew[+] [PATTERN] list foreign-data wrappers
\df[S+] [PATTERN] list functions
\dF[+] [PATTERN] list text search configurations
\dFd[+] [PATTERN] list text search dictionaries
\dFp[+] [PATTERN] list text search parsers
\dFt[+] [PATTERN] list text search templates
\dg [PATTERN] list roles (groups)
\di[S+] [PATTERN] list indexes
\dl list large objects, same as \lo_list
\dn[+] [PATTERN] list schemas
\do[S] [PATTERN] list operators
\dp [PATTERN] list table, view, and sequence access privileges
\z [PATTERN] same as \dp
\ds[S+] [PATTERN] list sequences
\dt[S+] [PATTERN] list tables
\dT[S+] [PATTERN] list data types
\du [PATTERN] list roles (users)
\dv[S+] [PATTERN] list views
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2009-01-07 00:08:57 | Re: Re: [COMMITTERS] pgsql: This makes all the \dX commands (most importantly to most: \df) |
Previous Message | Bruce Momjian | 2009-01-07 00:05:28 | pgsql: Add spaces around psql \d* columns, per idea from Joshua Drake. |
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2009-01-07 00:08:57 | Re: Re: [COMMITTERS] pgsql: This makes all the \dX commands (most importantly to most: \df) |
Previous Message | Tom Lane | 2009-01-06 23:50:03 | Re: Runaway backend at 100% CPU PostgreSQL v8.3.5 |