Re: retaining useful information on my screen

From: "Tim Bruce - Postgres" <postgres(at)tbruce(dot)com>
To: "Fred Parkinson" <FredP(at)abag(dot)ca(dot)gov>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: retaining useful information on my screen
Date: 2012-05-08 14:57:18
Message-ID: 34b60eee64ac8bdec24b57df7870ca16.squirrel@sm.tbruce.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2012-05-08 15:10:04 Re: retaining useful information on my screen
Previous Message Kevin Grittner 2012-05-08 14:38:35 Re: Advice/guideline on increasing shared_buffers and kernel parameters