X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 278589DCA3F for ; Tue, 21 Mar 2006 14:43:41 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 37537-01 for ; Tue, 21 Mar 2006 14:43:40 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id C3D889DCB10 for ; Tue, 21 Mar 2006 14:43:38 -0400 (AST) Received: by noel.decibel.org (Postfix, from userid 1001) id D8C0E5643D; Tue, 21 Mar 2006 12:43:36 -0600 (CST) Received: (hashcash-sendmail, from uid 1001); Tue, 21 Mar 2006 12:43:36 -0600 Date: Tue, 21 Mar 2006 12:43:36 -0600 From: "Jim C. Nasby" To: Dianne Yumul Cc: pgsql-admin@postgresql.org Subject: Re: use of in psql Message-ID: <20060321184336.GK15742@pervasive.com> References: <200603190215.k2J2FX118477@candle.pha.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060321:dianne@wellsgaming.com::duE5JwkKrYX4rCY+:000000000000000 0000000000000000000000000RSe X-Hashcash: 1:20:060321:pgsql-admin@postgresql.org::vF9s9OJTESClp8Z2:00000000000 0000000000000000000000000iT3 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.108 required=5 tests=[AWL=0.108] X-Spam-Score: 0.108 X-Spam-Level: X-Archive-Number: 200603/191 X-Sequence-Number: 20948 On Mon, Mar 20, 2006 at 10:03:28AM -0800, Dianne Yumul wrote: > On Mar 18, 2006, at 6:15 PM, Bruce Momjian wrote: > > >Luis P. Mendes wrote: > >>When I connect to a database via psql and do a select * from table; I > >>get the first page of results, considering \pset pager is on. > >> > >>In Debian, I can press the key to go directly to the last > >>results > >>or I can use or to move across the results. > >> > >>In the Slackware system, I can't do that. Can someone explain how to > >>activate this function? > > > >Sounds like the PAGER is set differently on the two systems. > > I have the same issue too. I can only use the space bar to go down > the results, page up and down keys do not work and neither does the > end key. > > I have Postgresql 8.0.6, FC 4. This is almost certainly not a PostgreSQL issue. Either the PAGER environment variable is set differently, or there's some issue with less/more/whatever you're using. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461