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
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: https://www.manitou-mail.org
Twitter: @DanielVerite