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?
> >
> >
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
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-#