pgAdmin II send messages to the output query window

How do I send messages to the output pane from the pgAdmin III query window?  

I have a large script that goes through many steps and takes about 5 minutes to run.  I want to put in audit lines, so I know where the progress of the script is.  Pseudo code would be: PRINT "Completed Step 1";

the "Print" function would pass the text to the output window and Completed Step 1 would appear in it...
FreightTrainAsked:
Who is Participating?
 
earth man2Commented:
If you are in plpgsql environment you can use RAISE NOTICE

file:///usr/share/doc/postgresql-8.2.5/html/plpgsql-errors-and-messages.html

RAISE NOTICE 'Calling cs_create_job(%)', v_job_id;
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.