Re: Maintaining blank lines in psql output?

[Ron <ronljohnsonjr@xxxxxxxxx>]

    On 1/17/23 15:22, David G. Johnston wrote:

On Tue, Jan 17, 2023 at 1:48 PM Ron <ronljohnsonjr@xxxxxxxxx> 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.