Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m6pnz-0000fu-NC for pgsql-hackers@arkaria.postgresql.org; Fri, 23 Jul 2021 07:41:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m6pny-0003nL-6p for pgsql-hackers@arkaria.postgresql.org; Fri, 23 Jul 2021 07:41:10 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m6pnx-0003nD-Vb for pgsql-hackers@lists.postgresql.org; Fri, 23 Jul 2021 07:41:09 +0000 Received: from sfr-1.cri.mines-paristech.fr ([77.158.180.225] helo=smtp.cri.ensmp.fr) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m6pnv-0008Kx-Kl for pgsql-hackers@lists.postgresql.org; Fri, 23 Jul 2021 07:41:09 +0000 Received: from pseudo (ip-160.net-81-220-45.lyon.rev.numericable.fr [81.220.45.160]) by smtp.cri.ensmp.fr (Postfix) with ESMTPSA id 03976C0024; Fri, 23 Jul 2021 09:43:11 +0200 (CEST) Date: Fri, 23 Jul 2021 09:41:05 +0200 (CEST) From: Fabien COELHO X-X-Sender: fabien@pseudo To: Pavel Stehule cc: Peter Eisentraut , "pgsql-hackers@lists.postgresql.org" Subject: Re: psql - add SHOW_ALL_RESULTS option In-Reply-To: Message-ID: References: <69C0B369-570C-4524-8EE4-BCCACECB6BEE@amazon.com> <20210412193301.GA11204@alvherre.pgsql> <3738387.1618451507@sss.pgh.pa.us> <451a2111-3757-c511-9413-8f8af531a167@enterprisedb.com> <18c78a01-4a34-9dd4-f78b-6860f1420c8e@enterprisedb.com> User-Agent: Alpine 2.22 (DEB 394 2020-01-19) MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII; format=flowed List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk >>> I tested manually for the pager feature, which mostly work, althoug >>> "pspg --stream" does not seem to expect two tables, or maybe there is >>> a way to switch between these that I have not found. >> >> pspg doesn't support this feature. Sure. Note that it is not a feature yet:-) ISTM that having some configurable pager-targetted marker would greatly help parsing on the pager side, so this might be the way to go, if this finally becomes a feature. -- Fabien.