From: | "Poul L(dot) Christiansen" <poulc(at)cs(dot)auc(dot)dk> |
---|---|
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 17:31:33 |
Message-ID: | 3A9BE475.6B7431BB@cs.auc.dk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
In PostgreSQL you can (almost) do this.
When i terminal mode logged in as user postgres use these commands:
1. "psql MyDatabase" to log into the database.
2. "select * from MyVeryBigTable"
3. Press space to view a page at the time.
I think you can enter regular expressions, instead of pressing space to
see the next page. But I don't know how to scroll up within the results.
Does anybody know if this is possible?
I'd suggest you browse the utilities in www.greatbridge.org - there
might be some smart tool to manage large tables.
Poul L. Christiansen
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.
>
> --
>
> NOTICE: The information contained in this electronic mail transmission is
> intended by Convergys Corporation for the use of the named individual or
> entity to which it is directed and may contain information that is
> privileged or otherwise confidential. If you have received this electronic
> mail transmission in error, please delete it from your system without
> copying or forwarding it, and notify the sender of the error by reply email
> or by telephone (collect), so that the sender's address records can be
> corrected.
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2001-02-27 17:54:10 | Re: Does PostGresSQL have this feature? |
Previous Message | Tom Lane | 2001-02-27 17:22:35 | Re: [SQL] Debug messages in beta5 |