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.chantler@convergys.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.