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?

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.


Reply via email to