X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 159A13A4184 for ; Mon, 25 Oct 2004 18:14:29 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 74758-01 for ; Mon, 25 Oct 2004 17:14:10 +0000 (GMT) Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by svr1.postgresql.org (Postfix) with ESMTP id 4B28E3A3AEC for ; Mon, 25 Oct 2004 18:14:10 +0100 (BST) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.1/8.13.1) with ESMTP id i9PHE68m039968 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Mon, 25 Oct 2004 11:14:08 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.1/8.13.1) with ESMTP id i9PHE6sd066808; Mon, 25 Oct 2004 11:14:06 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.1/8.13.1/Submit) id i9PHE6e0066807; Mon, 25 Oct 2004 11:14:06 -0600 (MDT) (envelope-from mfuhr) Date: Mon, 25 Oct 2004 11:14:05 -0600 From: Michael Fuhr To: "Goulet, Dick" Cc: pgsql-admin@postgresql.org Subject: Re: Psql question Message-ID: <20041025171405.GA66740@winnie.fuhr.org> References: <4001DEAF7DF9BD498B58B45051FBEA6501CC8C2F@25exch1.vicorpower.vicr.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4001DEAF7DF9BD498B58B45051FBEA6501CC8C2F@25exch1.vicorpower.vicr.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/335 X-Sequence-Number: 15328 On Mon, Oct 25, 2004 at 12:15:32PM -0400, Goulet, Dick wrote: > Anyone know how to turn off the --MORE-- option when a query returns? \pset pager This should toggle whether paging is used or not. You could also temporarily set the PAGER environment variable to "cat" or some other program that doesn't page. -- Michael Fuhr http://www.fuhr.org/~mfuhr/