> -----Original Message-----
> From: Rod Taylor [mailto:rbt@zort.ca]
> Sent: 26 August 2002 21:30
> To: Dave Page
> Cc: Karim R. Lakhani; pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] limiting the number of rows displayed
>
>
>
> > Hi Karim,
> >
> > Currently there is no way to do this other than enter the
> SQL yourself
> > with a 'LIMIT nnn' on the end of the query. It might be
> handy though,
> > so I'll add it to the todo list.
>
> MSAccess does this decently. They use a cursor, pull out 100
> entries by default, then when you scroll to the bottom of the
> screen it grabs the next 100 entries, etc.
>
> So, you only get as much as you want to see.
Using cursors is on the todo and has been for some while. The problem
has been lack of support in the ODBC driver, though iirc, Hiroshi has
fixed that now. I must look at it sometime when I get 5 minutes free
from work.
Regards, Dave.