Capturing only queries with --echo-hidden option?

From: Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com>
To: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Capturing only queries with --echo-hidden option?
Date: 2021-09-29 23:23:11
Message-ID: CAD3a31U=Td3n+yoLO0eQrBLHAwd2jvyR5T5ptNubaHop6VumyA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi. I was playing with the -E option a bit[1]. If I do for example a \d,
the queries and the regular output are interspersed on the screen. I see I
can use \o to send the regular output to a file, leaving only the queries
on the screen. But is there any way to do the reverse (capture the queries
to a file, output on screen), and/or send both streams to separate files?

If there isn't, would this gain any traction as a feature request?
Something like --echo-hidden=<filename>? I can't say it would be top of my
feature request list, but it seems like it could come in handy from
time-to-time, and maybe more so for others.

TIA & Cheers,
Ken

[1] I was wondering if it might be a helpful way to narrow down the
unrecognized node type error described in
https://www.postgresql.org/message-id/CADTdw-yGfNyHSLXajBFgCEod9dCh8Ys2%3D9j-gNh6kX5oEpkRNA%40mail.gmail.com

--
AGENCY Software
A Free Software data system
By and for non-profits
*http://agency-software.org/ <http://agency-software.org/>*
*https://demo.agency-software.org/client
<https://demo.agency-software.org/client>*
ken(dot)tanzer(at)agency-software(dot)org
(253) 245-3801

Subscribe to the mailing list
<agency-general-request(at)lists(dot)sourceforge(dot)net?body=subscribe> to
learn more about AGENCY or
follow the discussion.

Browse pgsql-general by date

  From Date Subject
Next Message Amine Tengilimoglu 2021-09-30 06:38:01 Re: ERROR: unrecognized node type
Previous Message Tomas Vondra 2021-09-29 21:10:06 Re: ERROR: unrecognized node type