?
Solved

pgAdmin II send messages to the output query window

Posted on 2007-10-18
1
Medium Priority
?
1,089 Views
Last Modified: 2008-01-09
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...
0
Comment
Question by:FreightTrain
1 Comment
 
LVL 22

Accepted Solution

by:
earth man2 earned 2000 total points
ID: 20103959
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

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many developers have database experience, but are new to PostgreSQL. It has some truly inspiring capabilities. I have several years' experience with Microsoft's SQL Server. When I began working with MySQL, I wanted a quick-reference to MySQL (htt…
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses
Course of the Month12 days, 21 hours left to enroll

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question