Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group