[ADMIN] retaining useful information on my screen

[Fred Parkinson]

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

[Tim Bruce - Postgres]

Post by Fred Parkinson
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.
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."

[Scott Marlowe]

On Tue, May 8, 2012 at 8:57 AM, Tim Bruce - Postgres

Post by Fred Parkinson
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.
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.

[Kevin Grittner]

Post by Fred Parkinson
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