[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Command to output display text in pl/pgsql

Posted on 2007-07-20
1
Medium Priority
?
1,788 Views
Last Modified: 2012-08-13
Is there a pl/pgsql equivalent to this Oracle command?

DBMS_OUTPUT.PUT.LINE('This outputs to display when this line runs');

?

-g
0
Comment
Question by:gmanpert
1 Comment
 
LVL 10

Accepted Solution

by:
adrpo earned 2000 total points
ID: 19539316

Hi,

You use RAISE in PostgreSQL.
RAISE level 'format' [, expression [, ...]];
Possible levels are DEBUG, LOG, INFO, NOTICE, WARNING, and EXCEPTION. EXCEPTION raises an error (which normally aborts the current transaction); the other levels only generate messages of different priority levels.
 
Have a look here for more info:
http://www.postgresql.org/docs/8.2/static/plpgsql-errors-and-messages.html

Cheers,
za-k/
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

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.
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses
Course of the Month19 days, 15 hours left to enroll

873 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