Re: psql -af > out, is possible to also have raise notice, raise info part.

On Tue, Jul 11, 2023 at 8:52 PM jian he <jian(dot)universality(at)gmail(dot)com> wrote:

> hi.
>
> test.sql content:
>
> --------------------------------------------------------------------------------------------------
> do $$
> begin
> raise info 'information message %', now() ;
> raise debug 'debug message %', now();
> raise notice 'notice message %', now();
> end $$;
>
> --------------------------------------------------------------------------------------------------
> psql -af test.sql > test.out
>
>
You've only redirected stdout (file # 1 - implied), the "raise" stuff goes
to stderr (file # 2)

IIRC you can do:

psql -af test.sql > test.out 2>&1

(order matters, left-to-right)

But you can search online for "output redirection in Linux" or some such if
you want to learn the Linux command line better.

David J.