Re: psql with "Function Type" in \df

Поиск
Список
Период
Сортировка
От David Fetter
Тема Re: psql with "Function Type" in \df
Дата
Msg-id 20090421163326.GJ15679@fetter.org
обсуждение исходный текст
Ответ на Re: psql with "Function Type" in \df  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: psql with "Function Type" in \df  (David Fetter <david@fetter.org>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: psql with "Function Type" in \df
Следующее
От: "steven king"
Дата:
Сообщение: Re: Automating Partitions in PostgreSQL - Query on syntax