From: Tom Lane <tgl@sss.pgh.pa.us>
To: "David G. Johnston" <david.g.johnston@gmail.com>
cc: lejeczek <peljasz@yahoo.co.uk>,
        "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
Subject: Re: What is paging my psql
In-reply-to: 
 <CAKFQuwbYJivMKDN4Uf14zj7ggkDsHi4tfVws-=6G41v8+NOx-A@mail.gmail.com>
References: <5844ca0b-4015-4c56-a43a-f44608185477.ref@yahoo.co.uk>
 <5844ca0b-4015-4c56-a43a-f44608185477@yahoo.co.uk>
 <CAKFQuwYBR-VLCs7qxL_oS81Lw_to5Gs0GZ5MsaYk0eaaZtHdJA@mail.gmail.com>
 <0dcb33c5-ca74-4003-9808-adfb4a2d3655@yahoo.co.uk>
 <CAKFQuwbYJivMKDN4Uf14zj7ggkDsHi4tfVws-=6G41v8+NOx-A@mail.gmail.com>
Comments: In-reply-to "David G. Johnston" <david.g.johnston@gmail.com>
	message dated "Fri, 21 Nov 2025 07:34:07 -0600"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <2180757.1763738171.1@sss.pgh.pa.us>
Date: Fri, 21 Nov 2025 10:16:11 -0500
Message-ID: <2180758.1763738171@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/2180758.1763738171%40sss.pgh.pa.us>
Precedence: bulk

"David G. Johnston" <david.g.johnston@gmail.com> writes:
> Whether the pager is used is conditioned on actual output data.

IIRC, you can do "\pset pager always" if you want the pager to be
invoked regardless of the query output length.

Be aware though that the default pager is "more", which (at least
on my Linux box) silently does nothing special if the output is less
than a screenful.  If the behavior you are looking for is "wait for
a keystroke even after very short output", you'd need to combine the
\pset setting with "export PSQL_PAGER=less" or similar.

			regards, tom lane