How to display a user-defined function?

Started by Erichover 25 years ago2 messagesgeneral
Jump to latest
#1Erich
hh@cyberpass.net

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

#2Darrin Ladd
darrin_ladd@hotmail.com
In reply to: Erich (#1)
Re: How to display a user-defined function?

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.