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 1pHv2w-0005xV-0F for pgsql-general@arkaria.postgresql.org; Tue, 17 Jan 2023 23:07:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pHv2u-000227-LM for pgsql-general@arkaria.postgresql.org; Tue, 17 Jan 2023 23:07:12 +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 1pHv2t-00021y-Qa for pgsql-general@lists.postgresql.org; Tue, 17 Jan 2023 23:07:12 +0000 Received: from ook.raf.org ([139.99.156.21]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pHv2o-0002og-Jv for pgsql-general@lists.postgresql.org; Tue, 17 Jan 2023 23:07:11 +0000 Received: from localhost (localhost [127.0.0.1]) by ook.raf.org (Postfix) with ESMTP id 79D0D5DFA1 for ; Wed, 18 Jan 2023 10:06:53 +1100 (AEDT) X-Virus-Scanned: Debian amavisd-new at ook.raf.org Received: from ook.raf.org ([127.0.0.1]) by localhost (ook.raf.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id FuXjJtg0VMZw for ; Wed, 18 Jan 2023 10:06:51 +1100 (AEDT) Received: by ook.raf.org (Postfix, from userid 1001) id 398EC61DD2; Wed, 18 Jan 2023 10:06:51 +1100 (AEDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=raf.org; s=001; t=1673996811; bh=1S0PxaXDFLDw6Ucc9FUqOZqCZOOBF38qc4ZEwEn/0FE=; h=Date:From:To:Subject:References:In-Reply-To:From; b=QSo3yB30d96OrhlDx5dppRucXaeyePC3KnYckA92qYJlcs6joBJiN7eidD05F7h1M AnvWwNknRXAc83DKOofqzYgUaZsgi0b+DdMe8q6HoNr06bIMKhb5rmBohU9stlPPTO GPNs6JWNMSynRykpjA1c9z8QUyT5AphxOj9p9kw4fQrNJ7ugHUA2+d+QDYWVtNBGci 9N8Is5DUhWXfW879vfJUUqGWsLcCqRnVxFKlIq04qA5N67hM3p+fq4Bi2TAI+n/SJu WpREp2+bmPDJ3QwaApiWZ4UF0A16mnWQl+XNg1wE/mr4p1hLORL44zaTABhdNFHBNp Bj1ssA0OhPxlw== Date: Wed, 18 Jan 2023 10:06:51 +1100 From: raf To: pgsql-general@lists.postgresql.org Subject: Re: Maintaining blank lines in psql output? Message-ID: References: <04db9247-4452-e9bb-e64a-1545e04d37bc@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Jan 17, 2023 at 02:22:22PM -0700, "David G. Johnston" wrote: > On Tue, Jan 17, 2023 at 1:48 PM Ron wrote: > > > > > White space can of course make things easy to read, but psql seems to > > ignore > > those blank lines. Is there any way to retain them in psql output? > > > > > Nope, there is no setting for psql to print all blank lines it encounters > to stdout. If you want to format your output with stuff other than query > results it provides \echo > > David J. Perhaps the best you can do is something like adding: select ''; or raise notice ''; It won't result in just a blank line, but it will separate things. cheers, raf