Re: psql > split > queries & output

Daniel Verite schreef op do 03-12-2020 om 15:18 [+0100]:
> Wim Bertels wrote:
>
> > * 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
>
> Consider that script:
>
> $ cat f.sql
> \set ECHO queries
> \o output.txt
> select 1;
> select 2;
> select 3;
>
> If it's run with
>
> $ psql -f f.sql >queries.txt
>
> then it produces the queries in queries.txt and the output in
> output.txt

thank you,
i use the same with a input file,
but interactively this doesn't seem to work

ie
psql > queries.txt (does not work (stdout))
(psql 2> queries.txt does work (stderr))
(psql &> queries.txt does not work (both))

--

psql -f - > out

does work interactively,
but no fun experience :) (no completion, and the separation does not
seem to work)

>
>
> Best regards,
--
mvg,
Wim
--
https://coronalert.be

--
If you laid all of our laws end to end, there would be no end.
-- Mark Twain