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

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Tue, Jul 11, 2023 at 8:52 PM jian he <jian.universality@xxxxxxxxx> 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.