Re: [GENERAL] Functions and procedures code!!!!

2003-08-04 Thread Tom Lane 
"=?iso-8859-1?Q?Freddy_Menj=EDvar_M.?=" <[EMAIL PROTECTED]> 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

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly

[GENERAL] Functions and procedures code!!!!

2003-08-04 Thread Freddy Menjívar M . 



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"?