title: Printing run time messages in postgres
body: <p>Can we use <code>RAISE NOTICE</code> in postgres as equivalent of <code>RAISERROR</code> 'message to display' <code>WITH NOWAIT</code> 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.</p>
  
  <pre><code>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;
  $$;
  </code></pre>
  
  <p>I apologize if this code is too bad to comment, pls do suggest a better way to do it, Thanks</p>