Re: expanded auto and header linestyle double

2017-11-16 21:16 GMT+01:00 Matt Zagrabelny <mzagrabe(at)d(dot)umn(dot)edu>:

> Thanks for the reply, Pavel!
>
> On Thu, Nov 16, 2017 at 1:01 AM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
> wrote:
>
>> Hi
>>
>> 2017-11-15 23:37 GMT+01:00 Matt Zagrabelny <mzagrabe(at)d(dot)umn(dot)edu>:
>>
>>> Greetings,
>>>
>>> Using PG 10.1.
>>>
>>> In my .psqlrc I have:
>>>
>>> \x auto
>>> \pset linestyle 'unicode'
>>> \pset unicode_header_linestyle double
>>>
>>> and when the output is expanded, I do not see a double line for the
>>> first record, but I do for all subsequent records. For example:
>>>
>>> % select * from artist;
>>> ─[ RECORD 1 ]─────────────────────────
>>> artistid │ 1
>>> name │ AC/DC
>>> ═[ RECORD 2 ]═════════════════════════
>>> artistid │ 2
>>> name │ Accept
>>> ═[ RECORD 3 ]═════════════════════════
>>> artistid │ 3
>>> name │ Aerosmith
>>> ═[ RECORD 4 ]═════════════════════════
>>> artistid │ 4
>>> name │ Alanis Morissette
>>> ═[ RECORD 5 ]═════════════════════════
>>> artistid │ 5
>>>
>>> I would like to have the initial "RECORD 1" line have the same "double"
>>> linestyle as the other records.
>>>
>>> Am I missing a config item?
>>>
>>
>> yes - it is border line
>>
>> use \pset border 2
>>
>>
> Hmmm.... I didn't use the "border" setting.
>
>
>> and you understand
>>
>> you are missing
>>
>> \pset unicode_border_linestyle double
>>
>
> But I did use the above setting.
>
> So my .psqlrc looks like:
>
> \pset linestyle 'unicode'
> \pset unicode_border_linestyle double
> \pset unicode_header_linestyle double
>
> ═[ RECORD 1 ]════════════════
> artistid │ 1
> name │ AC/DC
> ═[ RECORD 2 ]════════════════
> artistid │ 2
> name │ Accept
> ═[ RECORD 3 ]════════════════
> artistid │ 3
> name │ Aerosmith
>
> Thanks for helping me get it corrected.
>
> It still feels strange that when using "expanded" display the first record
> separator would be categorized under "border_linestyle" and the remaining
> record separators would be categorized under "header_linestyle".
>

There is some simplification - this line is header and together border. It
has sense when you use border 2

Regards

Pavel

> Cheers!
>
> -m
>