Output from PLPGSQL

--On Wednesday, September 03, 2003 13:19:03 +0200 Amin Schoeib
<aschoeib@4tek.de> 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

see RAISE NOTICE.

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

hello

use raise notice ''some message'';
http://www.postgresql.org/docs/7.3/interactive/plpgsql-errors-and-messages.html
try to read documentation for plpgsq (very usefull)
http://www.postgresql.org/docs/7.3/interactive/plpgsql.html
and chapter for converison from Oracle
http://www.postgresql.org/docs/7.3/interactive/plpgsql-porting.html

bye
Pavel

On Wed, 3 Sep 2003, Amin Schoeib wrote:

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.

--
Richard Huxton
Archonet Ltd

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