test=# select pg_get_functiondef(oid) test-# from pg_proc test-# where proname = 'foo'; pg_get_functiondef ---------------------------------------------------- CREATE OR REPLACE FUNCTION public.foo(bar integer)+ RETURNS double precision + LANGUAGE plpgsql + AS $function$ + begin + return bar * 1.0; + end; + $function$ + (1 row) -- Born in Arizona, moved to Babylonia.
Is there any direct way in Postgresql to get rid of the frankly anti-useful
junk at the end of each line (which also infects pg_stat_activity.query), or
must I resort to sed post-processing?
- pg_get_functiondef(), trailing spaces and + sign Ron
- Re: pg_get_functiondef(), trailing spaces and + sign Adrian Klaver
- Re: pg_get_functiondef(), trailing spaces and + sign Adrian Klaver