Re: Maintaining blank lines in psql output? - Mailing list pgsql-general

From Ron
Subject Re: Maintaining blank lines in psql output?
Date
Msg-id bcae0f82-42f8-78ad-9faf-0072bf940125@gmail.com
Whole thread Raw
In response to Re: Maintaining blank lines in psql output?  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
On 1/17/23 15:22, David G. Johnston wrote:
On Tue, Jan 17, 2023 at 1:48 PM Ron <ronljohnsonjr@gmail.com> 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

\echo is exactly what I want, not only because of it's simplicity but since it doesn't generate numbers when \timing is enabled.

(The primary use is for sql scripts generated by bash scripts and run from cron, where stdout and stderr are redirected to a log file.)

--
Born in Arizona, moved to Babylonia.

pgsql-general by date:

Previous
From: raf
Date:
Subject: Re: Maintaining blank lines in psql output?
Next
From: Adrian Klaver
Date:
Subject: Re: Tablespace OID, database OID, relfilenode