Re: psql with "Function Type" in \df - Mailing list pgsql-hackers

From David Fetter
Subject Re: psql with "Function Type" in \df
Date
Msg-id 20090421165742.GK15679@fetter.org
Whole thread Raw
In response to Re: psql with "Function Type" in \df  (David Fetter <david@fetter.org>)
Responses Re: psql with "Function Type" in \df  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
On Tue, Apr 21, 2009 at 09:33:26AM -0700, David Fetter wrote:
> On Tue, Apr 21, 2009 at 09:26:13AM -0700, Joshua D. Drake wrote:
> > On Tue, 2009-04-21 at 12:19 -0400, Alvaro Herrera wrote:
> >
> > > I suggested this to Bruce over IM:
> > >
> > > \df[antw][S+]     list [only agg/normal/trigger/window] functions
> > >
> > > (one line only, removing the second redundant line).  This seems
> > > clea[nr]er to me.  Bruce says it would confuse users.  But really, if
> > > you can understand the [S+] stuff you should be able to get the [antw]
> > > stuff too, right?
> > >
> >
> > +1 to Alvaro.
>
> Now psql allows you to mix all of the options freely (scary math word
> ahead) in an idempotent way.  In other words, this works:
>
> \df++aannSw
>
> Expressed as a regex, it's \\df[antwS+]*
>
> Cheers,
> David.

Oh, and I forgot to send some error-handling and cleanup code per
Alvaro.  Please find attached. :)

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

Attachment

pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: psql with "Function Type" in \df
Next
From: David Fetter
Date:
Subject: Re: New trigger option of pg_standby