Re: psql: \pset pager 'always'?

There is a patch at:

http://candle.pha.pa.us/cgi-bin/pgpatches2

which will allow you to turn on the pager always. This is for 7.4.

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

Martijn van Oosterhout wrote:
> On Wed, Sep 18, 2002 at 01:40:42PM -0000, greg(at)turnstep(dot)com wrote:
> >
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
> >
> >
> > > 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.
> >
> > Easily done, but I am not sure that this is the right thing to do.
> > A pager is designed to handle excess vertical input, but not all
> > can handle excess horizontal input (the width). I suspect that doing
> > so would not be a good idea for the same reason given to me when I
> > asked "why not send everything to the pager?": some systems force you
> > to specifically exit the pager; this can be real annoying for cases
> > with small input.
>
> While this is true, if you do a select whose output wraps because it is too
> wide, getting it to go through "less -S" is extremely useful to have the
> columns line up. OTOH, sending everything to the pager is annoying if the
> result is only one value.
>
> I'd be happy with an easier way to force the pager than "\g |less -S".
> Perhaps if \g is specified without a filename, it defaults to the pager.
> Would such a patch be accepted?
>
> --
> 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.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

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