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 20090421163326.GJ15679@fetter.org
Whole thread Raw
In response to Re: psql with "Function Type" in \df  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: psql with "Function Type" in \df  (David Fetter <david@fetter.org>)
List pgsql-hackers
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.
-- 
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


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: psql with "Function Type" in \df
Next
From: "steven king"
Date:
Subject: Re: Automating Partitions in PostgreSQL - Query on syntax