Search Postgresql Archives

Re: Maintaining blank lines in psql output?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

cheers,
raf






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux