Re: psql: \pset pager 'always'?

Can someone supply a patch to automatically invoke the pager if the
output width is greater than the screen?  We already test for screen
rows but not for screen width.

---------------------------------------------------------------------------

Martijn van Oosterhout wrote:
> On Thu, Sep 12, 2002 at 10:20:45AM +0930, Justin Hawkins wrote:
> > antti.haapala@iki.fi (Antti Haapala) writes:
> >
> > > I don't know if this is already done, but...
> > >
> > > I'm really annoyed by that little 'feature' of psql that decides whether
> > > to use pager or not. I personally use GNU 'less' with options -S -F as my
> > > pager, which allows me to scroll vertically AS WELL AS horizontally on
> > > long input. So a "use pager always"  option with no strange automagic
> > > behaviour would be nice. Or do you consider this being readable (copyed
> > > verbatim from terminal window):
> >
> > Yes, I'd like to second that.
> >
> > My ugly workaround when I need to have less invoked (so I can scroll
> > sideways) and the result set it small (in rows), I make my window very
> > small (vertically), run the query, then stretch it out again.
>
> Remember, you can always use \g like this:
>
> select * from table \g |less -S
>
> Maybe not neat, but very effective.
> --
> Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> > There are 10 kinds of people in the world, those that can do binary
> > arithmetic and those that can't.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073