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

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.