retaining useful information on my screen

Поиск
Список
Период
Сортировка
Искать

retaining useful information on my screen

От:
"Fred Parkinson" <FredP@abag.ca.gov>
Дата:
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

Re: retaining useful information on my screen

От:
"Tim Bruce - Postgres" <postgres@tbruce.com>
Дата:
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 -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

Re: retaining useful information on my screen

От:
Scott Marlowe <scott.marlowe@gmail.com>
Дата:
On Tue, May 8, 2012 at 8:57 AM, Tim Bruce - Postgres
 wrote:
> 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 -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."

I often do:

export PAGER=/bin/cat

when I want even less interference.

Re: retaining useful information on my screen

От:
"Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Дата:
"Fred Parkinson"  wrote:
 
> 2. Is there way to tell psql NOT to clear the screen, so I can
> subsequently view it while I work?
 
\pset pager off
 
-Kevin
FAQ