Re: Is there an equivalent in plpgsql of Oracle's DBMS_OUTPUT.PUT_LINE?

From: Joe Conway <mail(at)joeconway(dot)com>
To: Glenn_Wiens(at)via-christi(dot)org
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Is there an equivalent in plpgsql of Oracle's DBMS_OUTPUT.PUT_LINE?
Date: 2003-09-23 15:11:53
Message-ID: 3F7062B9.8020408@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Glenn_Wiens(at)via-christi(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Juan Francisco Diaz 2003-09-23 22:08:38 Concatenating
Previous Message Bruno LEVEQUE 2003-09-23 14:49:11 Re: Is there an equivalent in plpgsql of Oracle's DBMS_OUTPUT.PUT_LINE?