Re: psql: \pset pager 'always'? - Mailing list pgsql-general

From Bruce Momjian
Subject Re: psql: \pset pager 'always'?
Date
Msg-id 200209182104.g8IL4BM00892@candle.pha.pa.us
Whole thread Raw
In response to Re: psql: \pset pager 'always'?  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
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@turnstep.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@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 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>

--
  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

pgsql-general by date:

Previous
From: Jeff Boes
Date:
Subject: Database uptime?
Next
From: Tom Lane
Date:
Subject: Re: Permissions with multiple groups...