st 1. 7. 2020 v 22:41 odesÃlatel Tom Lane <t...@sss.pgh.pa.us> napsal:
> Pavel Stehule <pavel.steh...@gmail.com> writes: > > I propose new psql environment variable PSQL_WATCH_PAGER. When this > > variable is not empty, then \watch command starts specified pager, and > > redirect output to related pipe. When pipe is closed - by pager, then > > \watch cycle is leaved. > > I dunno, this just seems really strange. With any normal pager, > you'd get completely unusable behavior (per the comments that you > didn't bother to change). Also, how would the pager know where > the boundaries between successive query outputs are? If it does > not know, seems like that's another decrement in usability. > This feature is designed for specialized pagers - now only pspg can work in this mode. But pspg is part of RH, Fedora, Debian, and it is available on almost Unix platforms. https://github.com/okbob/pspg the pspg knows the psql output format of \watch statement. The usability of this combination - psql \watch and pspg is really good. Regards Pavel > regards, tom lane >