Re: proposal - psql - possibility to redirect only tabular output - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: proposal - psql - possibility to redirect only tabular output
Date
Msg-id CAFj8pRCiBvG1F43EO-TQRqt4zkcpYU_M-spen9rjHxU=z6D7=g@mail.gmail.com
Whole thread Raw
In response to Re: proposal - psql - possibility to redirect only tabular output  (Artur Zakirov <zaartur@gmail.com>)
List pgsql-hackers


pá 3. 7. 2020 v 12:16 odesílatel Artur Zakirov <zaartur@gmail.com> napsal:
Hello,

On Sat, Apr 11, 2020 at 6:20 PM Pavel Stehule <pavel.stehule@gmail.com> wrote:
> Main motivation for this patch is working with psql for writing and editing queries, and browsing result in second terminal with pspg or any other similar tool (tail, ...). The advantage of this setup is possibility to see sql and query result together. I use terminal multiplicator (Tilix), but it can be used without it.
>
> So example with pspg (should be some fresh release)
>
> 1. create fifo used for communication - mkfifo ~/pipe
>
> 2. run in one terminal pspg - pspg -f ~/pipe --hold-stream=2
>
> 3. run psql in other terminal

The patch looks interesting. As far as I understand the purpose of the
patch is to hide status messages from result output.
So maybe it would be enough just to hide status messages at all. There
is the QUIET variable for that. The main advantage of this variable is
that it hides a status of "\lo_" commands, for example, as well as a
status of utility commands. So the QUIET variable covers more use
cases already.

The quiet mode isn't exactly what I want (it can be used as a workaround - and now, pspg https://github.com/okbob/pspg knows a format of status line and can work it).

I would like to see a status row. For me it is a visual check so some statements like INSERT or UPDATE was done successfully. But I would not send it to the terminal with an active tabular pager.

Pavel




--
Artur

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: track_planning causing performance regression
Next
From: Movead Li
Date:
Subject: Re: A patch for get origin from commit_ts.