Thread: get source of udf

get source of udf

From
Peter Kroon
Date:
Hi list,

I would like to get the source of a udf.
In mssql I run this query:
SELECT OBJECT_DEFINITION(OBJECT_ID) FROM sys.objects WHERE name='function_name';
And I get the entire source of the function.

How must I do this in PostgreSQL?

Thanks,
Peter

Re: get source of udf

From
Pavel Stehule
Date:
Hello

postgres=# select pg_get_functiondef('fx'::regproc);
                pg_get_functiondef
--------------------------------------------------
 CREATE OR REPLACE FUNCTION public.fx(_m integer)+
  RETURNS void                                   +
  LANGUAGE plpgsql                               +
 AS $function$                                   +
 declare m double precision = 10;                +
         n double precision = 20022.222;         +
   r double precision;                           +
 begin                                           +
   for i in 1.._m                                +
   loop                                          +
     r := m * n;                                 +
   end loop;                                     +
 end;                                            +
 $function$                                      +

(1 row)

regards

Pavel Stehule

2012/11/20 Peter Kroon <plakroon@gmail.com>:
> Hi list,
>
> I would like to get the source of a udf.
> In mssql I run this query:
> SELECT OBJECT_DEFINITION(OBJECT_ID) FROM sys.objects WHERE
> name='function_name';
> And I get the entire source of the function.
>
> How must I do this in PostgreSQL?
>
> Thanks,
> Peter