Postgres Pro
Downloads
Home   >   mailing lists

Re: Is there an equivalent in plpgsql of Oracle's DBMS_OUTPUT.PUT_LINE? - Mailing list pgsql-novice

From Joe Conway
Subject Re: Is there an equivalent in plpgsql of Oracle's DBMS_OUTPUT.PUT_LINE?
Date
Msg-id 3F7062B9.8020408@joeconway.com
Whole thread Raw
In response to Is there an equivalent in plpgsql of Oracle's DBMS_OUTPUT.PUT_LINE?  (Glenn_Wiens@via-christi.org)
List pgsql-novice
Tree view 
Glenn_Wiens@via-christi.org wrote:
> I am somewhat new to PostgreSQL's procedure language, and I have not been
> able to find a way to do ad-hoc outputs to the console from plpgsql
> functions -- mostly for debugging purposes. Oracle has the DBMS_OUTPUT
> package which included the PUT_LINE() function. Is there something like
> this in plpgsql?

Try RAISE NOTICE -- see:
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=plpgsql-errors-and-messages.html

Joe

pgsql-novice by date:

Previous
From: Glenn_Wiens@via-christi.org
Date:
Subject: Is there an equivalent in plpgsql of Oracle's DBMS_OUTPUT.PUT_LINE?
Next
From: Juan Francisco Diaz
Date:
Subject: Concatenating