Re: pg_get_functiondef(), trailing spaces and + sign

2023-02-27 Thread Kirk Wolak
On Mon, Feb 27, 2023 at 2:40 PM Adrian Klaver wrote: > 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? > > > >

Re: pg_get_functiondef(), trailing spaces and + sign

2023-02-27 Thread Adrian Klaver
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? Or \ef foo test=# select pg_get_functiondef(oid) test-# from pg_p

Re: pg_get_functiondef(), trailing spaces and + sign

2023-02-27 Thread Adrian Klaver
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-#