Postgres Pro
Downloads
Home   >   mailing lists

Re: How to prevent clear screen when query finish ? - Mailing list pgsql-general

From Alban Hertroys
Subject Re: How to prevent clear screen when query finish ?
Date
Msg-id CAF-3MvMTG=Cq7GSh9RWCJUtzzg0+TVmJO-YR9LFHAKmLnVbZcw@mail.gmail.com
Whole thread Raw
In response to Re: How to prevent clear screen when query finish ?  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses How to find transaction ID  ("ascot.moss@gmail.com" <ascot.moss@gmail.com>)
List pgsql-general
Tree view
On 7 August 2013 18:01, Adrian Klaver <adrian.klaver@gmail.com> wrote:
On 08/07/2013 08:53 AM, Condor wrote:
http://www.postgresql.org/docs/9.2/interactive/app-psql.html

pager
Controls use of a pager program for query and psql help output. If the environment variable PAGER is set, the output is piped to the specified program. Otherwise a platform-dependent default (such as more) is used.--

If you use less for pager and want this behaviour system-wide, you'll want to set another env variable: setenv LESS -X (I use tcsh) or export LESS=-X if you use bash.

That makes less behave properly (not clearing the screen) after closing man-pages and such.

--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.

pgsql-general by date:

Previous
From: Chris Travers
Date:
Subject: Re: How to prevent clear screen when query finish ?
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: Performance of ORDER BY RANDOM to select random rows?