need help with \df (user defined function listing)

From: Medi Montaseri <medi(at)cybershell(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: need help with \df (user defined function listing)
Date: 2002-02-05 03:43:35
Message-ID: 3C5F54E7.A2A51F0E@cybershell.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Thanks

--
-------------------------------------------------------------------------
Medi Montaseri medi(at)CyberShell(dot)com
Unix Distributed Systems Engineer HTTP://www.CyberShell.com
CyberShell Engineering
-------------------------------------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2002-02-05 05:04:20 Re: sequence question
Previous Message Gerhard Pfeiffer 2002-02-05 03:24:39 rule on update