From: | jian he <jian(dot)universality(at)gmail(dot)com> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | pgsql-general list <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: psql -af > out, is possible to also have raise notice, raise info part. |
Date: | 2023-07-12 04:27:02 |
Message-ID: | CACJufxHGNEygP5q0NU=fKf4Eskc7GT1y2=r98n1t6RO7cBvU_w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Jul 12, 2023 at 12:06 PM David G. Johnston
<david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>
> 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.
>
thanks.
I don't know that "raise" stuff goes to stderr.
To get rid of the line numbers, I use "psql -a < test.sql > test.out
2>&1 " to get the expected result.
From | Date | Subject | |
---|---|---|---|
Next Message | Johnathan Tiamoh | 2023-07-12 04:39:49 | Re: Need Help On Upgrade |
Previous Message | David G. Johnston | 2023-07-12 04:05:51 | Re: psql -af > out, is possible to also have raise notice, raise info part. |