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

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:

Yeah, I know what you mean! It took me a while of just weeding through the
system tables to finally find where this was stored! If you do the
following, then you'll see what you want:

select prosrc from pg_proc where proname = '<function name>'

just replace the <function name> with your function's name and you've got
it!

Darrin

From: Erich <hh@cyberpass.net>
To: pgsql-general@postgresql.org
Subject: [GENERAL] Help! How to find the definition of a user-defined
function
Date: Sun, 10 Sep 2000 15:59:59 -0700 (PDT)

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

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at
http://profiles.msn.com.