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