Re: echo/printf function in plpgsql

From: Richard Huxton <dev(at)archonet(dot)com>
To: Andreas Joseph Krogh <andreak(at)officenet(dot)no>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: echo/printf function in plpgsql
Date: 2005-07-19 15:18:54
Message-ID: 42DD19DE.60106@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Andreas Joseph Krogh wrote:
> Hi all!
>
> Is there a way of echo'ing a string(like "raise notice 'this is id%', id")
> from plpgsql? I want to echo/print it to STDOUT 'cause the notice-mechanism
> produces too much noise IMH.

Your function is running in the backend. You don't have a STDOUT
(although you might have redirected STDERR for logging).

--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas Joseph Krogh 2005-07-19 15:58:05 Re: echo/printf function in plpgsql
Previous Message Andreas Joseph Krogh 2005-07-19 14:51:28 echo/printf function in plpgsql