psql -af > out, is possible to also have raise notice, raise info part.
От | jian he |
---|---|
Тема | psql -af > out, is possible to also have raise notice, raise info part. |
Дата | |
Msg-id | CACJufxFhzBCAikuQOStLt0VXLFEWJd4bgxzHvv7dVu-tOA+QZg@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: psql -af > out, is possible to also have raise notice, raise info part.
|
Список | pgsql-general |
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 current result: -------------------------------------------------------------------------------------------------- do $$ begin raise info 'information message %', now() ; raise notice 'notice message %', now(); end $$; DO -------------------------------------------------------------------------------------------------- expected result in test.out do $$ begin raise info 'information message %', now() ; raise notice 'notice message %', now(); end $$; INFO: information message 2023-07-12 11:49:27.894126+08 NOTICE: notice message 2023-07-12 11:49:27.894126+08 DO
В списке pgsql-general по дате отправления: