Re: [PATCHES] selecting large result sets in psql using - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PATCHES] selecting large result sets in psql using
Date
Msg-id 12409.1156286015@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PATCHES] selecting large result sets in psql using  (<chrisnospam@1006.org>)
Responses Re: [PATCHES] selecting large result sets in psql using
List pgsql-hackers
<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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Where is hstore?
Next
From: Greg Stark
Date:
Subject: Re: Tricky bugs in concurrent index build