Re: need help with \df (user defined function listing) - Mailing list pgsql-general

From Stephan Szabo
Subject Re: need help with \df (user defined function listing)
Date
Msg-id 20020204210434.L84083-100000@megazone23.bigpanda.com
Whole thread Raw
In response to need help with \df (user defined function listing)  (Medi Montaseri <medi@cybershell.com>)
List pgsql-general
On Mon, 4 Feb 2002, Medi Montaseri wrote:

> Hi,
>
> I am looking for a plpgsql function I wrote a while ago and I can not
> find it.
> I redirect the out put to a file with \o /tmp/foo, then a \df and from
> OS I grep
> with no avail. My function name was foo* (foo-something). When I do a
> \df foo*
> I get a definition, but the report does not include a name.  I need to
> drop this function,
> so I need a exact name.
>
> Where does \df get it from, is it in any of the pg_* tables.

Well, the data should be in pg_proc, but \df should give it to you.



pgsql-general by date:

Previous
From: "Gerhard Pfeiffer"
Date:
Subject: rule on update
Next
From: Stephan Szabo
Date:
Subject: Re: sequence question