Re: limiting the number of rows displayed

From: Rod Taylor <rbt(at)zort(dot)ca>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: "Karim R(dot) Lakhani" <lakhani(at)MIT(dot)EDU>, pgadmin-support(at)postgresql(dot)org
Subject: Re: limiting the number of rows displayed
Date: 2002-08-26 20:29:33
Message-ID: 1030393775.29269.15.camel@jester
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgadmin-support


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

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2002-08-26 20:32:10 Re: limiting the number of rows displayed
Previous Message Vikram Khurana 2002-08-26 20:23:55 Re: VMWare connection