Re: psql > split > queries & output
От
Pavel Stehule
Тема
Re: psql > split > queries & output
Дата
Msg-id
CAFj8pRA+wZdkU5SrUR2a7j4JguTqg=qhPKZ567fHViA6WU-Whg@mail.gmail.com
Ответ на
psql > split > queries & output (Wim Bertels)
Список
Дерево обсуждения
psql > split > queries & output Wim Bertels <wim.bertels@ucll.be>
Re: psql > split > queries & output "Daniel Verite" <daniel@manitou-mail.org>
Re: psql > split > queries & output Wim Bertels <wim.bertels@ucll.be>
Re: psql > split > queries & output "Daniel Verite" <daniel@manitou-mail.org>
Re: psql > split > queries & output Wim Bertels <wim.bertels@ucll.be>
Re: psql > split > queries & output Pavel Stehule <pavel.stehule@gmail.com>
čt 3. 12. 2020 v 12:39 odesílatel Wim Bertels <wim.bertels@ucll.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
В списке pgsql-general по дате отправления
От: Pavel Stehule
Дата: