From: | "Norman J(dot) Clarke" <norman(at)combimatrix(dot)com> |
---|---|
To: | martin(dot)chantler(at)convergys(dot)com |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Does PostGresSQL have this feature? |
Date: | 2001-02-27 19:52:11 |
Message-ID: | Pine.LNX.4.21.0102271147350.6865-100000@curly.combimatrix.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Martin,
What platform are you running psql on? On Unix all you have to do is set
your shell environment variable PAGER (PAGER=more or PAGER=less) and psql
will then do what you want. If you're running it on Windows, though, I'm
not sure what to suggest. If your postgresql installation is running on a
Unix server, you might telnet to that machine and run psql from there.
Norm
--------------------------------------
Norman Clarke
Combimatrix Corp Software Development
Harbour Pointe Tech Center
6500 Harbour Heights Pkwy, Suite 301
Mukilteo, WA 98275
tel: 425.493.2240
fax: 425.493.2010
--------------------------------------
On Tue, 27 Feb 2001 martin(dot)chantler(at)convergys(dot)com wrote:
> I am wondering if a very useful feature of some DB's is available in
> postgres
>
> For example in DB2 you can execute SQL from the command line (via terminal
> emulator)
> It will perform it entirely then display the results, but only one page at
> a time
> You can then page down and page up within the results (or scroll across)
>
> I notice that PSQL doesn't do this which makes large tables difficult to
> maintain
> Of course you could put a decent Where clause in but in the real world most
> people
> like to narrow things down to a certain point then scroll around a few
> hundred records
> looking for the data by hand. Currently this doesn't seem to be possible
>
> The only way I can think of doing this is to write a program in C (or use
> ODBC/JDBC) to
> perform the SQL then retrieve x records and display them and allows paging
> to be performed
> When paging down the current set would be cached so that page up's would be
> possible
>
> Doing this in VB would be easy and you could allow data to be editted to...
>
> NB Unfortunately MS Access is no good because it tries to load ALL the data
> in one go and
> you CANT get out of it!!!
>
> Anyone got any better ideas???
>
> Martin C.
From | Date | Subject | |
---|---|---|---|
Next Message | David Lynn | 2001-02-27 20:07:26 | Odd behavior with views and numeric columns |
Previous Message | Tom Lane | 2001-02-27 19:34:50 | Re: Re: Slowdown problem when writing 1.7million records |