Re: Request - repeat value of \pset title during \watch interations - Mailing list pgsql-general

From David G. Johnston
Subject Re: Request - repeat value of \pset title during \watch interations
Date
Msg-id CAKFQuwZeEmtCqcueUCF4F4qRXHb+OYT6W2JbM-kzWVXv-NMPcA@mail.gmail.com
Whole thread Raw
In response to Re: Request - repeat value of \pset title during \watch interations  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-general
On Thu, Jan 28, 2016 at 9:07 PM, Michael Paquier <michael.paquier@gmail.com> wrote:


On Fri, Jan 29, 2016 at 1:55 AM, David G. Johnston wrote:
> Could you run the following and post the result, please?  I have yet to
> setup a compiled-from-source installation...
>
> \pset title 'This is a medium length title'
> SELECT repeat('a', 100) \watch 5
>
> It seems fine though I'm curious how it plays with various combinations of
> narrow and wide outputs on narrow and wide terminals - specifically the
> centering
>  
> aspect that occurs when the table is wider than the Watch/Time content.  The
> terminal width should just cause wrapping relative to a wide-enough terminal
> so really it just the centering aspect when the table is wider than the
> header.

No problem. Here you go:

                               Watch every 5s    Fri Jan 29 13:06:31 2016

This is a medium length title
                                                repeat                                              
------------------------------------------------------------------------------------------------------
 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
(1 row)
--
Michael

​Looks good to me.

Thank You!

David J.
 

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: apt.postgresql.org ubtuntu trusty missing libpq version
Next
From: Vick Khera
Date:
Subject: Re: ERROR: check constraint - PostgreSQL 9.2