Re: patch: psql - enforce constant width of last column

On Tue, Sep 17, 2019 at 05:15:42PM +0200, Pavel Stehule wrote:
> 
> 
> út 17. 9. 2019 v 17:06 odesílatel Ahsan Hadi <ahsan.hadi@gmail.com> napsal:
> 
>     Hi Pavel,
> 
>     I have been trying to reproduce the case of badly displaying last columns
>     of a query result-set. I played around with the legal values for psql
>     border variable but not able to find a case where last columns are badly
>     displayed. Can you please share an example that I can use to reproduce this
>     problem. I will try out your patch once I am able to reproduce the problem.
> 
> 
> you need to use pspg, and vertical cursor.
> 
> https://github.com/okbob/pspg
> vertical cursor should be active
> 
> \pset border 1
> \pset linestyle ascii
> \pset pager always
> 
> select * from generate_series(1,3);

I was able to reproduce the failure, but with a little more work:

    $ export PSQL_PAGER='pspg --vertical-cursor'
    $ psql test
    \pset border 1
    \pset linestyle ascii
    \pset pager always
    select * from generate_series(1,3);

Line '1' has highlighted trailing space.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +