pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tim Bruce - Postgres <postgres@tbruce.com>
To: Fred Parkinson <FredP@abag.ca.gov>
Cc: pgsql-admin@postgresql.org
Subject: Re: retaining useful information on my screen
Date: Tue, 8 May 2012 07:57:18 -0700
Message-ID: <34b60eee64ac8bdec24b57df7870ca16.squirrel@sm.tbruce.com> (raw)
In-Reply-To: <4FA8CB21020000A70001C6EA@gwia1.abag.ca.gov>
References: <4FA8CB21020000A70001C6EA@gwia1.abag.ca.gov>

On Tue, May 8, 2012 07:28, Fred Parkinson wrote:
> I am currently using postgresql version 9.1.3
>
> In the past, when I ran psql and needed useful information provided by
> commands like \h or \d, the information was presented on the screen and I
> could proceed with further commands while viewing the information.
>
> Now I need to hit <shift>-q to get out of the \h or \d request, and the
> information disappears from the screen as well.
>
> 2 questions:
> 1. what was the problem presented by leaving the information up on the
> screen, which is now solved by removing the information from the screen?
>
> 2. Is there way to tell psql NOT to clear the screen, so I can
> subsequently view it while I work?
>
> Thanks.
>
>
> Fred Parkinson
> Application Programmer
> Association of Bay Area Governments
> 510-464-7931
>

Set the environment variable PAGER to solve this problem.  I usually set
it with the following command in my .bashrc file

export PAGER='less -X'

NOTE: That's an uppercase X after the Unix command "less."

-- 
Timothy J. Bruce




view thread (4+ messages)  latest in thread

Message-ID: <34b60eee64ac8bdec24b57df7870ca16.squirrel@sm.tbruce.com>
Permalink:  ../34b60eee64ac8bdec24b57df7870ca16.squirrel@sm.tbruce.com/
Also on:    postgresql.org/message-id/34b60eee64ac8bdec24b57df7870ca16.squirrel@sm.tbruce.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: postgres@tbruce.com, FredP@abag.ca.gov
  Subject: Re: retaining useful information on my screen
  In-Reply-To: <34b60eee64ac8bdec24b57df7870ca16.squirrel@sm.tbruce.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox