Thanks Erik, the \o | tee outfile does the trick. Never thought of that.
It appears to exclude the output from psql I think like \conninfo or \encoding.
Is there a way to get those to show in the outfile too? This is the same for when not using tee as well.
On 2024-02-07 10:16 +0100, Edwin UY wrote:
> Is there any way for psql to output to the console AND file at the same
> time?
> \o redirect the output to the file but at the same time it suppresses the
> output to the console :(
>
> I am wanting to redirect the output to a file for the psql session for the
> SQL/SQL-script that I ran while at the same see the same output to screen.
>
> Thought I can use tee -a but I can't :(
Why not? That was my first idea.
$ psql | tee outfile
But the psql prompt is not printed on the console and tab completion via
readline does not work. Maybe I'm missing something.
What does work is using \o and redirect to tee:
$ psql finance
psql (16.1)
Type "help" for help.
postgres=# \o | tee outfile
postgres=# select now();
now
-------------------------------
2024-02-07 11:08:23.207647+01
(1 row)
postgres=# \q
$ cat outfile
now
-------------------------------
2024-02-07 11:08:23.207647+01
(1 row)
> Using script [outputfile] seems to work. Just thought maybe there is any
> other psql trick besides using script. The script has lots of control
> characters :(
--
Erik