Re: controlling psql's use of the pager a bit more - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: controlling psql's use of the pager a bit more
Date
Msg-id 5464DF41.10805@dunslane.net
Whole thread Raw
In response to Re: controlling psql's use of the pager a bit more  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: controlling psql's use of the pager a bit more  (David G Johnston <david.g.johnston@gmail.com>)
Re: controlling psql's use of the pager a bit more  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
On 11/13/2014 11:09 AM, Tom Lane wrote:
> Andrew Dunstan <andrew@dunslane.net> writes:
>> I often get annoyed because psql is a bit too aggressive when it decides
>> whether to put output through the pager, and the only way to avoid this
>> is to turn the pager off (in which case your next query might dump many
>> thousands of lines to the screen). I'd like a way to be able to specify
>> a minumum number of lines of output before psql would invoke the pager,
>> rather than just always using the terminal window size.
> Are you saying you'd want to set the threshold to *more* than the window
> height?  Why?


Because I might be quite happy with 100 or 200 lines I can just scroll 
in my terminal's scroll buffer, but want to use the pager for more than 
that. This is useful especially if I want to scroll back and see the 
results from a query or two ago.



cheers

andrew



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: REINDEX CONCURRENTLY 2.0
Next
From: "Tomas Vondra"
Date:
Subject: Re: WIP: multivariate statistics / proof of concept