Do a '\g | more' instead of the ';' at the end of the query. Much easier:
select * from table \g | more
--------------------------------------------------------------------------
Aaron Holtz
ComNet Inc.
UNIX Systems Specialist
Email: aholtz@bright.net
"It's not broken, it just lacks duct tape."
--------------------------------------------------------------------------
On Jun 22, Jeff MacDonald molded the electrons to say....
>When I do a large select , the results all zip past the screen
>. How do I make it go page by page ? I figure this has to do
>with a term setting, my default term setting is 'linux' .
>I tried vt100 and vt220 .
>
>Perhaps this is a linux-ism ?
>
>Thanks
> Jeff
>
>
>