Re: [PATCHES] selecting large result sets in psql using

<chrisnospam@1006.org> writes:
> To cut the Gordon knot I'm going to suggest we use:

> \set CURSOR_FETCH fetch_count

> and \g and ; are modified such that when they see
> this variable set to fetch_count > 0 and the buffer
> is a select they would use the modified fetch/output code.

> Does this sound reasonable to everyone?

OK with me, but maybe call the variable FETCH_COUNT, to avoid the
presupposition that the implementation uses a cursor.  As I mentioned
before, I expect we'll someday rework it to not use that.
        regards, tom lane