Search Postgresql Archives

Re: Procedures

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux