On 1/17/23 15:22, David G. Johnston 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.