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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
