Re: Default "maximum rows to retrieve" setting

One of the useful things about the frontend/backend protocol (http://
www.postgresql.org/docs/8.2/interactive/protocol.html) is that it
provides a way to set a value for the maximum number of rows to
return. This avoids the major hassle of trying to analyze the query
and figure out how to add a limit clause. Unfortunately, I don't
recall seeing a way set this using libpq or EXECUTE.

John

On Mar 19, 2007, at 5:03 AM, Dave Page wrote:

>> Ideally what I'd like is to set the default rows to retrieve to
>> 1000, so
>> it downloads the first 1000 rows when I open the table, and then I
>> can
>> choose to retrieve others if I need to.
>
> That would be a whole different patch. Feel free to submit one :-)

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL