Re: How to output psql to file AND screen/console

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 Wed, Feb 7, 2024 at 11:11 PM Erik Wienhold <ewie@xxxxxxxxx> wrote:
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

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux