Re: Printing values on pgadmin tool window using plperlu

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Harpreet Dhaliwal <harpreet(dot)dhaliwal01(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Printing values on pgadmin tool window using plperlu
Date: 2007-05-14 05:36:23
Message-ID: 20070514053623.GA2348@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, May 13, 2007 at 11:51:55PM -0400, Harpreet Dhaliwal wrote:
> I have a function written in language plpelu.
> Normally, values in perl code are printed using
> print statement.
> Then same when used in postgres environment won't print messages in
> 'Messages' tab to pgadmin query tool window.
> How and where can I print these values while running the plperlu function.

Use elog().

http://www.postgresql.org/docs/8.2/interactive/plperl-database.html

--
Michael Fuhr

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Purusothaman A 2007-05-14 07:45:10 OID - file object, are damaged by PostgreSQL.
Previous Message Jasbinder Singh Bali 2007-05-14 05:08:26 EXCEPTION clause not identified