Re: Output from PLPGSQL

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Output from PLPGSQL
Date: 2003-09-04 22:36:49
Message-ID: bj8epu$i6m$1@sea.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Richard Huxton schrieb:

> On Wednesday 03 September 2003 12:19, Amin Schoeib wrote:
>
>>Hi,
>>How can I make textoutput (for example for tracing the code) in PLPGSQL.
>>In Oracle you can do that using dbms.output.put_line
>
>
> RAISE NOTICE ''My counter is % with total %'',i,run_tot;
>
> Double-quoted string as usual in plpgsql - won't handle expressions for the
> string part.
>
I'm wondering how these messages can be accessed using JDBC?

Is this stored in the Warning Object for the connection, or the statement,
or do I have to call some special methods, to read this messages?

Regards
Thomas

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-09-04 23:08:01 Re: tablelevel and rowlevel locks
Previous Message Ron Johnson 2003-09-04 22:23:30 Re: Backup?