Re: echo/printf function in plpgsql - Mailing list pgsql-sql

From Richard Huxton
Subject Re: echo/printf function in plpgsql
Date
Msg-id 42DD19DE.60106@archonet.com
Whole thread Raw
In response to echo/printf function in plpgsql  (Andreas Joseph Krogh <andreak@officenet.no>)
Responses Re: echo/printf function in plpgsql
List 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


pgsql-sql by date:

Previous
From: Andreas Joseph Krogh
Date:
Subject: echo/printf function in plpgsql
Next
From: Andreas Joseph Krogh
Date:
Subject: Re: echo/printf function in plpgsql