From: | John DeSoi <desoi(at)pgedit(dot)com> |
---|---|
To: | Dave Page <dpage(at)postgresql(dot)org> |
Cc: | andy(dot)shellam-lists(at)mailnetwork(dot)co(dot)uk, PgAdmin Support Mailing List <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Default "maximum rows to retrieve" setting |
Date: | 2007-03-20 00:03:44 |
Message-ID: | 662CD9A5-A1B1-40DE-990F-1D89BBF4680C@pgedit.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2007-03-20 08:27:07 | Re: Default "maximum rows to retrieve" setting |
Previous Message | Andy Shellam | 2007-03-19 10:48:01 | Re: Default "maximum rows to retrieve" setting |