Re: controlling psql's use of the pager a bit more

On Thu, Nov 13, 2014 at 8:14 AM, Andres Freund <andres(at)2ndquadrant(dot)com>
wrote:

> On 2014-11-13 11:09:06 -0500, Tom Lane wrote:
> > Andrew Dunstan <andrew(at)dunslane(dot)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