Re: psql: \pset pager 'always'?

On Thu, Sep 12, 2002 at 10:20:45AM +0930, Justin Hawkins wrote:
> antti(dot)haapala(at)iki(dot)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(at)svana(dot)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.