Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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


pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group