Re: Maintaining blank lines in psql output?

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Maintaining blank lines in psql output?
Дата
Msg-id CAKFQuwYHQH8uXFWFXaiCtmuYPpXkvqgO_k4ZbrPwO4YpH-8=wg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Maintaining blank lines in psql output?  (raf <raf@raf.org>)
Ответы Re: Maintaining blank lines in psql output?  (raf <raf@raf.org>)
Список pgsql-general
On Tue, Jan 17, 2023 at 4:07 PM raf <raf@raf.org> wrote:
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.


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.

В списке pgsql-general по дате отправления:

Предыдущее
От: raf
Дата:
Сообщение: Re: Maintaining blank lines in psql output?
Следующее
От: raf
Дата:
Сообщение: Re: Maintaining blank lines in psql output?