subject:"\[GENERAL\] get source of udf"

Re: [GENERAL] get source of udf

2012-11-20 Thread Pavel Stehule

Hello postgres=# select pg_get_functiondef('fx'::regproc); pg_get_functiondef -- CREATE OR REPLACE FUNCTION public.fx(_m integer)+ RETURNS void + LANGUAGE plpgsql +

[GENERAL] get source of udf

2012-11-19 Thread Peter Kroon

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