Thread: How to display a user-defined function?

How to display a user-defined function?

From
Erich
Date:
I declared a function using CREATE FUNCTION.  Is there a way I can
display the function back?  I tried \df, etc, but I couldn't figure
out how to do it.

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: How to display a user-defined function?

From
"Darrin Ladd"
Date:
The source of the defined function is held in pg_proc.prosrc

ie: SELECT prosrc FROM pg_proc WHERE proname = 'function_name';


>From: Erich <hh@cyberpass.net>
>To: pgsql-general@postgresql.org
>Subject: [GENERAL] How to display a user-defined function?
>Date: Wed, 6 Sep 2000 12:40:21 -0700 (PDT)
>
>I declared a function using CREATE FUNCTION.  Is there a way I can
>display the function back?  I tried \df, etc, but I couldn't figure
>out how to do it.
>
>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.