Re: Separate the result of \watch for each query execution (psql) - Mailing list pgsql-hackers

From Noboru Saito
Subject Re: Separate the result of \watch for each query execution (psql)
Date
Msg-id CAAM3qnLnrjE5Bn9c96KOGbyezkaPgopj0fU9UM9P8eKvfTca6g@mail.gmail.com
Whole thread Raw
In response to Re: Separate the result of \watch for each query execution (psql)  (Noboru Saito <noborusai@gmail.com>)
Responses Re: Separate the result of \watch for each query execution (psql)  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: Separate the result of \watch for each query execution (psql)  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Separate the result of \watch for each query execution (psql)  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Hi,

Pavel Stehule <pavel.stehule@gmail.com>:
> > I strongly agree. It was a lot of work to find a workable solution for pspg. Special chars that starting result and
maybeother, that ending result can significantly increase robustness and can reduce code. I think it can be better to
useform feed at the end of form - like it is semantic of form feed. You know, at this moment, the result is complete.
https://en.wikipedia.org/wiki/Page_break
>
> It's easier to print a form feed before the result, but it's okay at the end.
>
> > I don't think using it by default can be the best. Lot of people don't use specialized pagers, but it can be set by
\pset.Form feed should be used on end 
> >
> > \pset formfeed [on, off]
>
> I think it's a good idea to be able to switch with \pset.

I have created a patch that allows you to turn it on and off in \pset.
The attached patch adds the following features.


Formfeed can be turned on with the command line option or \pset.
Formfeed (\f\n) is output after the query execution result by \watch.

I think the considerations are as follows.

* Is formfeed output after the result, not before?
* Is the formfeed output only "\f\n"?
* Is the formfeed output only executed by \watch?
* Is the name "formfeed" appropriate?

If the formfeed is output before the query result,
it will be better if the screen is reset when the formfeed is read.

Furthermore, if the terminal clear string can be set instead of the
formfeed character,
the \watch output can be fixedly displayed without a pager.

(I noticed that if I set it in the title, it would behave similarly in
the current version.
    # \C '\033[2J;\033[0;0H'
    # SELECT now();\watch 1
)

Also, it may be good to output formfeed when outputting a file with
`\o result.txt`
other than \watch.

Attachment

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Optionally automatically disable logical replication subscriptions on error
Next
From: "Imseih (AWS), Sami"
Date:
Subject: Re: [BUG] Panic due to incorrect missingContrecPtr after promotion