| From: | jian he <jian(dot)universality(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general list <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | psql -af > out, is possible to also have raise notice, raise info part. |
| Date: | 2023-07-12 03:52:26 |
| Message-ID: | CACJufxFhzBCAikuQOStLt0VXLFEWJd4bgxzHvv7dVu-tOA+QZg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2023-07-12 04:05:51 | Re: psql -af > out, is possible to also have raise notice, raise info part. |
| Previous Message | Benedict Holland | 2023-07-12 01:31:35 | Re: Need Help On Upgrade |