Thread: limiting the number of rows displayed

limiting the number of rows displayed

From
"Karim R. Lakhani"
Date:
Hello all,

I am working with a fairly large database (some tables have over 100,000
rows).  Wondering if there is a way to limit the number of rows that can
be viewed when I do   "view data".  Could not see that as an option in
the program.

Thanks

karim

Re: limiting the number of rows displayed

From
"Dave Page"
Date:

> -----Original Message-----
> From: Karim R. Lakhani [mailto:lakhani@MIT.EDU]
> Sent: 26 August 2002 17:42
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] limiting the number of rows displayed
>
>
> Hello all,
>
> I am working with a fairly large database (some tables have
> over 100,000 rows).  Wondering if there is a way to limit the
> number of rows that can
> be viewed when I do   "view data".  Could not see that as an option in
> the program.

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.

Regards, Dave.

Re: limiting the number of rows displayed

From
"Dave Page"
Date:

> -----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.

Re: limiting the number of rows displayed

From
Rod Taylor
Date:
> 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.