Re: psql > split > queries & output

čt 3. 12. 2020 v 12:39 odesílatel Wim Bertels <wim(dot)bertels(at)ucll(dot)be> napsal:

> Hello,
>
> psql shows (the queries and) the output,
> there are for example the -L option and echo_queries option
>
> is there a way to run psql so that:
> * inside psql there are no surprises :) (ignore this line:)
> * one pipe (or..) to a file which only contains the statements
> (queries) history (and not the output)
> * another pipe (or..) to a file which only contains the output (with or
> without the statements) history
>
> why? for example,
> to have easy access in a psql demonstration to past commands
> (history),
> without the output cluttering or overwhelming everything, side by side
> on the screen. (optionally with a third pane for the output)
>
> there is also the /s option in psql,
> but i guess the history is only written to file when psql is closed,
> and is not accessible during the session (only in memory?),
> otherwise this would also be an option
> (not ctrl+r)
>
> suggestions or alternatives while using the commandline?
>

Unfortunately it is not possible. Both contents are sent to stdout. The
own hack can be pretty easy, but without it it is not possible.

Regards

Pavel

> --
> mvg,
> Wim
> --
> https://coronalert.be
>
>
> --
> Always do right. This will gratify some people and astonish the rest.
> -- Mark Twain
>
>
>
>