Printing run time messages in postgres

Question

Can we use RAISE NOTICE in postgres as equivalent of RAISERROR 'message to display' WITH NOWAIT in SQL Server, or is there a better way to print intermediate messages while postgres queries are running? Please suggest if there is better way to print run time messages in postgres.

INSERT INTO tbl1 (col1) values (val1); DO $$ begin raise notice 'insert tbl1 done!'; end; $$; UPDATE tbl2 set col2='val2' where ...; DO $$ begin raise notice 'update tbl2 done!'; end; $$; 

I apologize if this code is too bad to comment, pls do suggest a better way to do it, Thanks

Answer 1

you can use very simple statement in function everywhere.

DO $$ begin raise notice '%',now(); end; $$; 

function for reference:

create or replace function test() RETURNS bool AS ' begin raise notice ''%'',now(); for i IN 0..50000000  loop      end loop      raise notice ''%'',now();      return true; end; 

LANGUAGE 'plpgsql';

Answer 2

Yes, you can use RAISE NOTICE like below. It's correct the way you are doing.

RAISE NOTICE 'i want to print % and %', var1,var2; 

See here for more information https://www.postgresql.org/docs/current/static/plpgsql-errors-and-messages.html

EDIT:

begin INSERT INTO tbl1 (col1) values (val1); raise notice 'insert tbl1 done!'; end;