Thread: Help! How to find the definition of a user-defined function

Help! How to find the definition of a user-defined function

From
Erich
Date:
I defined a function in PL/pgsql using CREATE FUNCTION.  Is there a
way to view the function that is now defined?  I read through all the
docs, and I couldn't find anything that seemed like it would work.

Thanks,

e

--
This message was my two cents worth.  Please deposit two cents into my
e-gold account by following this link:
http://rootworks.com/twocentsworth.cgi?102861
275A B627 1826 D627 ED35  B8DF 7DDE 4428 0F5C 4454

Re: Help! How to find the definition of a user-defined function

From
Stephan Szabo
Date:
Right now, you can find the text via:

SELECT prosrc from pg_proc where proname=<name>;


Stephan Szabo
sszabo@bigpanda.com

On Sun, 10 Sep 2000, Erich wrote:

>
> I defined a function in PL/pgsql using CREATE FUNCTION.  Is there a
> way to view the function that is now defined?  I read through all the
> docs, and I couldn't find anything that seemed like it would work.