From: | Matt Zagrabelny <mzagrabe(at)d(dot)umn(dot)edu> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: expanded auto and header linestyle double |
Date: | 2017-11-16 20:16:50 |
Message-ID: | CAOLfK3VQJNbMjzq_5BhsJND7wqNrKtQyi-EVqEiT6E+5DSu6oQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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".
Cheers!
-m
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2017-11-16 20:46:22 | Re: expanded auto and header linestyle double |
Previous Message | rammohan ganapavarapu | 2017-11-16 16:58:42 | Re: Can master and slave on different PG versions? |