get source of udf
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
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>:
Show quoted text
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