Re: expanded auto and header linestyle double

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

In response to

Responses

Browse pgsql-general by date

  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?