Re: Default "maximum rows to retrieve" setting

[John DeSoi <desoi(at)pgedit(dot)com>]

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