Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id E4F3112CE35B for ; Tue, 8 May 2012 11:57:37 -0300 (ADT) Received: from dsl001-133-246.pdx1.dsl.speakeasy.net ([72.1.133.246] helo=pc015.kb0odu.us) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SRlr5-0004Ao-9S for pgsql-admin@postgresql.org; Tue, 08 May 2012 14:57:37 +0000 Received: by pc015.kb0odu.us (Postfix, from userid 901) id 25496A05A; Tue, 8 May 2012 07:57:20 -0700 (PDT) X-Spam-Checker-Version: SpamAssassin 3.3.1 (2010-03-16) on pc015.kb0odu.us X-Spam-Level: X-Spam-Status: No, score=-2.9 required=5.0 tests=ALL_TRUSTED,BAYES_00 autolearn=unavailable version=3.3.1 Received: from sm.tbruce.com (localhost [127.0.0.1]) by pc015.kb0odu.us (Postfix) with ESMTP id 2CDD6A047; Tue, 8 May 2012 07:57:18 -0700 (PDT) Received: from 192.168.8.23 (SquirrelMail authenticated user timb) by sm.tbruce.com with HTTP; Tue, 8 May 2012 07:57:18 -0700 Message-ID: <34b60eee64ac8bdec24b57df7870ca16.squirrel@sm.tbruce.com> In-Reply-To: <4FA8CB21020000A70001C6EA@gwia1.abag.ca.gov> References: <4FA8CB21020000A70001C6EA@gwia1.abag.ca.gov> Date: Tue, 8 May 2012 07:57:18 -0700 Subject: Re: retaining useful information on my screen From: "Tim Bruce - Postgres" To: "Fred Parkinson" Cc: pgsql-admin@postgresql.org Reply-To: postgres@tbruce.com User-Agent: SquirrelMail/1.4.21 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 X-Priority: 3 (Normal) Importance: Normal Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: 1.8 (+) X-Archive-Number: 201205/40 X-Sequence-Number: 39529 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=3D'less -X' NOTE: That's an uppercase X after the Unix command "less." --=20 Timothy J. Bruce