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

From Jeff Janes
Subject Re: controlling psql's use of the pager a bit more
Date
Msg-id CAMkU=1ziGHkN9N0bxD3-uDmOSF+PEAud+90K3N1Sc+L5P7xJSA@mail.gmail.com
Whole thread Raw
In response to Re: controlling psql's use of the pager a bit more  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
On Thu, Nov 13, 2014 at 8:14 AM, Andres Freund <andres@2ndquadrant.com> wrote:
On 2014-11-13 11:09:06 -0500, 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?

Not sure what that'd be useful for.

What I've noticed more than once is that it'd be useful to force the
pager if the result is wider than the screen.

For which formats do you want that?  It is already done that way under \pset format aligned.


Cheers,

Jeff

pgsql-hackers by date:

Previous
From: Jeff Janes
Date:
Subject: Re: controlling psql's use of the pager a bit more
Next
From: Merlin Moncure
Date:
Subject: Re: controlling psql's use of the pager a bit more