Re: Procedures

On 02/20/2010 06:51 PM, Thomas Kellerer wrote:
> Nilesh Govindarajan wrote on 20.02.2010 14:08:
>> On 02/20/2010 02:32 PM, John R Pierce wrote:
>>> Nilesh Govindarajan wrote:
>>>> How do I create a procedure using plpgsql cursors to print the output
>>>> of the query in the cursor (using for loop) ?
>>>>
>>>> In all docs I found, it seems to be a must to return data to the call
>>>> which is not what I want.
>>>>
>>>
>>> what is it going to print it on? the postgres server processes have no
>>> console or stdout device.
>>
>> Okay, so how do I print it to stdout ?
>>
> Even if you could, that would be stdout of the *server*, not the one of
> the client calling the procedure!
>
> Regards
> Thomas
>
>
>

Okay how to stdout it to the client ?

The reason is, I have a query which I need to run repeatedly to see if
some data has been inserted by the web application. So its irritating to
type the query again and again.

--
Nilesh Govindarajan
Site & Server Adminstrator
www.itech7.com