By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,661 Members | 1,330 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,661 IT Pros & Developers. It's quick & easy.

Output from PLPGSQL

P: n/a
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

Thanxx

Schoeib

4Tek Gesellschaft für angewandte Informationstechnologien mbH
Schoeib Amin
Tel. +49 (0) 69 697688-132
Fax. +49 (0) 69 697688-111
http://www.4tek.de
Nov 11 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a


--On Wednesday, September 03, 2003 13:19:03 +0200 Amin Schoeib
<as******@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: le*@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 11 '05 #2

P: n/a
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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 11 '05 #3

P: n/a
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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 11 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.