pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedretaining useful information on my screen
4+ messages / 4 participants
[nested] [flat]
* retaining useful information on my screen
@ 2012-05-08 14:28 Fred Parkinson <FredP@abag.ca.gov>
0 siblings, 2 replies; 4+ messages in thread
From: Fred Parkinson @ 2012-05-08 14:28 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: retaining useful information on my screen
@ 2012-05-08 14:57 Tim Bruce - Postgres <postgres@tbruce.com>
parent: Fred Parkinson <FredP@abag.ca.gov>
1 sibling, 1 reply; 4+ messages in thread
From: Tim Bruce - Postgres @ 2012-05-08 14:57 UTC (permalink / raw)
To: Fred Parkinson <FredP@abag.ca.gov>; +Cc: 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: retaining useful information on my screen
@ 2012-05-08 15:10 Scott Marlowe <scott.marlowe@gmail.com>
parent: Tim Bruce - Postgres <postgres@tbruce.com>
0 siblings, 0 replies; 4+ messages in thread
From: Scott Marlowe @ 2012-05-08 15:10 UTC (permalink / raw)
To: postgres@tbruce.com; +Cc: Fred Parkinson <FredP@abag.ca.gov>; pgsql-admin
On Tue, May 8, 2012 at 8:57 AM, Tim Bruce - Postgres
<postgres@tbruce.com> 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 <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."
I often do:
export PAGER=/bin/cat
when I want even less interference.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: retaining useful information on my screen
@ 2012-05-08 15:11 Kevin Grittner <Kevin.Grittner@wicourts.gov>
parent: Fred Parkinson <FredP@abag.ca.gov>
1 sibling, 0 replies; 4+ messages in thread
From: Kevin Grittner @ 2012-05-08 15:11 UTC (permalink / raw)
To: Fred Parkinson <FredP@abag.ca.gov>; pgsql-admin
"Fred Parkinson" <FredP@abag.ca.gov> 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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2012-05-08 15:11 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-05-08 14:28 retaining useful information on my screen Fred Parkinson <FredP@abag.ca.gov>
2012-05-08 14:57 ` Tim Bruce - Postgres <postgres@tbruce.com>
2012-05-08 15:10 ` Scott Marlowe <scott.marlowe@gmail.com>
2012-05-08 15:11 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
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