Re: Output from PLPGSQL - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: Output from PLPGSQL
Date
Msg-id bj8epu$i6m$1@sea.gmane.org
Whole thread Raw
In response to Re: Output from PLPGSQL  (Richard Huxton <dev@archonet.com>)
List 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


pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Backup?
Next
From: "scott.marlowe"
Date:
Subject: Re: Activate Index