Thread: Functions and procedures code!!!!

Functions and procedures code!!!!

From
Freddy Menjívar M.
Date:
is there any way to get user's
functions and procedures
code from postgresql system catalog.
 
if a create a function something like
 
----------------------------------------
CREATE OR REPLACE FUNCTION myfunction()
RETURNS INTEGER
 
AS'
BEGIN
    my code ....;
END;
' LANGUAGE 'plpgsql';
----------------------------------------
How can I retrieve "my code"?

Re: Functions and procedures code!!!!

From
Tom Lane
Date:
"=?iso-8859-1?Q?Freddy_Menj=EDvar_M.?=" <mmfreddy@hotmail.com> writes:
> is there any way to get user's
> functions and procedures
> code from postgresql system catalog.

Sure, just look at pg_proc.prosrc for your function.

            regards, tom lane