Re: psql - pager support - using invisible chars for signalling end of report

2023-09-12 Thread Peter Eisentraut
On 06.09.23 05:07, Thomas Munro wrote: This sounds better than the QUERY_SEPARATOR hack from commit 664d757531e, and similar kludges elsewhere. I think Pavel and David are right about NUL being impossible in psql query output, no? Note: -z, --field-separator-zero

Re: psql - pager support - using invisible chars for signalling end of report

2023-09-07 Thread Daniel Gustafsson
> On 6 Sep 2023, at 05:07, Thomas Munro wrote: > This sounds better than the QUERY_SEPARATOR hack from commit > 664d757531e, and similar kludges elsewhere. I think Pavel and David > are right about NUL being impossible in psql query output, no? +1, I would love to be able to rip out that hack.

Re: psql - pager support - using invisible chars for signalling end of report

2023-09-05 Thread Thomas Munro
On Sat, Apr 25, 2020 at 3:53 PM Pavel Stehule wrote: > so 25. 4. 2020 v 2:12 odesílatel Tom Lane napsal: >> Pavel Stehule writes: >> > pá 24. 4. 2020 v 21:33 odesílatel Tom Lane napsal: >> >> And what will happen when those characters are in the data? >> >> > It will be used on pager side as si

Re: psql - pager support - using invisible chars for signalling end of report

2020-04-24 Thread Pavel Stehule
so 25. 4. 2020 v 2:12 odesílatel Tom Lane napsal: > Pavel Stehule writes: > > pá 24. 4. 2020 v 21:33 odesílatel Tom Lane napsal: > >> And what will happen when those characters are in the data? > > > It will be used on pager side as signal so previous rows was really last > > row of result, and

Re: psql - pager support - using invisible chars for signalling end of report

2020-04-24 Thread David G. Johnston
On Fri, Apr 24, 2020 at 5:12 PM Tom Lane wrote: > Pavel Stehule writes: > > pá 24. 4. 2020 v 21:33 odesílatel Tom Lane napsal: > >> And what will happen when those characters are in the data? > > > It will be used on pager side as signal so previous rows was really last > > row of result, and n

Re: psql - pager support - using invisible chars for signalling end of report

2020-04-24 Thread Tom Lane
Pavel Stehule writes: > pá 24. 4. 2020 v 21:33 odesílatel Tom Lane napsal: >> And what will happen when those characters are in the data? > It will be used on pager side as signal so previous rows was really last > row of result, and new row will be related to new result. In other words, it wil

Re: psql - pager support - using invisible chars for signalling end of report

2020-04-24 Thread Pavel Stehule
pá 24. 4. 2020 v 21:33 odesílatel Tom Lane napsal: > Pavel Stehule writes: > > I had a idea using some invisible chars, that are usually ignored (and > use > > these special characters only when user would it). > > And what will happen when those characters are in the data? > It will be used on

Re: psql - pager support - using invisible chars for signalling end of report

2020-04-24 Thread Tom Lane
Pavel Stehule writes: > I had a idea using some invisible chars, that are usually ignored (and use > these special characters only when user would it). And what will happen when those characters are in the data? regards, tom lane

psql - pager support - using invisible chars for signalling end of report

2020-04-24 Thread Pavel Stehule
Hi Last release of pspg supports stream mode - it means so you can open psql in one terminal, redirect output to named pipe. In second terminal you can start pspg and read input from named pipe. Then you can see and edit SQL in one terminal, and you can see a result in second terminal. It is work