On Tue, Jan 17, 2023 at 4:07 PM raf <r...@raf.org> wrote: > On Tue, Jan 17, 2023 at 02:22:22PM -0700, "David G. Johnston" < > david.g.johns...@gmail.com> wrote: > > > On Tue, Jan 17, 2023 at 1:48 PM Ron <ronljohnso...@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 > > > > 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. > > Those both seem much more complicated than \echo for the same (or worse) effect. You'd have to wrap the raise notice inside a do block which itself would then be executed by the server...
David J.
