Re: psql -af > out, is possible to also have raise notice, raise info part.
| От | David G. Johnston |
|---|---|
| Тема | Re: psql -af > out, is possible to also have raise notice, raise info part. |
| Дата | |
| Msg-id | CAKFQuwaiOYoRYfVPPQfjzsAZqVEfUVQ-7F3Dtev2Lq3FfQOOJA@mail.gmail.com обсуждение исходный текст |
| Ответ на | psql -af > out, is possible to also have raise notice, raise info part. (jian he <jian.universality@gmail.com>) |
| Ответы |
Re: psql -af > out, is possible to also have raise notice, raise info part.
|
| Список | pgsql-general |
On Tue, Jul 11, 2023 at 8:52 PM jian he <jian.universality@gmail.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.
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.
В списке pgsql-general по дате отправления: