Re: Maintaining blank lines in psql output?

On Tue, Jan 17, 2023 at 02:22:22PM -0700, "David G. Johnston" <david.g.johnston@gmail.com> 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
>
> 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.