On 2/27/23 11:34 AM, Ron wrote:
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?
\pset format unaligned
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)
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx
