Luke Lonergan wrote: > Tom, > > On 2/2/07 2:18 PM, "Tom Lane" <[EMAIL PROTECTED]> wrote: > >> as of 8.2 there's a psql variable >> FETCH_COUNT that can be set to make it happen behind the scenes.) > > FETCH_COUNT is a godsend and works beautifully for exactly this purpose. > > Now he's got to worry about how to page through 8GB of results in something > less than geological time with the space bar ;-)
\o /tmp/really_big_cursor_return ;) Joshua D. Drake > > - Luke > > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: You can help support the PostgreSQL project by donating at > > http://www.postgresql.org/about/donate > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
