Re: BUG #5143: psql \df doesn't recogize patterns

From: Piotr Woliński <pwolinski(at)dfqs(dot)pl>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5143: psql \df doesn't recogize patterns
Date: 2009-10-28 15:43:43
Message-ID: 4AE866AF.6090801@dfqs.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Alvaro Herrera pisze:
> Piotr Wolinski wrote:
>
>
>> It looks like pqsl \df command doesn't recognize regexp pattern.
>>
>
> No, it doesn't use regexes, only shell patterns (* and ? only).
>
>
Is documentation correct? There is descprition just like \dt \dv and
other commands.

http://www.postgresql.org/docs/8.4/interactive/app-psql.html

\df[antwS+] [ /pattern/ ]

Lists available functions, together with their arguments, return
types, and their function types: 'agg' (aggregate), 'normal',
'trigger', and 'window'. To display only functions of a specific
type, use the corresponding letters a, n, t, or w. If /pattern/ is
specified, only functions whose names match the pattern are shown.
If the form \df+ is used, additional information about each
function, including volatility, language, source code and
description, is shown. By default, only user-created objects are
shown; supply a pattern or the S modifier to include system objects.

--
Piotr Woliński, biuro IT

Dom Finansowy QS Sp. z o.o. z siedzibą w Gdańsku, ul. Piastowska 11,
wpisany do Rejestru Przedsiębiorców Krajowego Rejestru Sądowego
przez Sąd Rejonowy Gdańsk-Północ w Gdańsku pod numerem KRS 66674,
z kapitałem zakładowym w wysokości 50.000,00 PLN, NIP 957-08-11-591.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2009-10-28 15:50:28 Re: BUG #5143: psql \df doesn't recogize patterns
Previous Message Alvaro Herrera 2009-10-28 15:34:00 Re: BUG #5143: psql \df doesn't recogize patterns