Re: Maintaining blank lines in psql output?

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.)