Re: [GENERAL] expanded auto and header linestyle double - Mailing list pgsql-general

From Pavel Stehule
Subject Re: [GENERAL] expanded auto and header linestyle double
Date
Msg-id CAFj8pRCH6vCyXtkOYbexVFx34t1k8=OyKsgXMVFXozfMWSGS_Q@mail.gmail.com
Whole thread Raw
In response to [GENERAL] expanded auto and header linestyle double  (Matt Zagrabelny <mzagrabe@d.umn.edu>)
Responses Re: [GENERAL] expanded auto and header linestyle double  (Matt Zagrabelny <mzagrabe@d.umn.edu>)
List pgsql-general
Hi

2017-11-15 23:37 GMT+01:00 Matt Zagrabelny <mzagrabe@d.umn.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

and you understand

you are missing

\pset unicode_border_linestyle double

Regards

Pavel


Thanks!

-m

pgsql-general by date:

Previous
From: Jeff Janes
Date:
Subject: Re: [GENERAL] pg_basebackup running from a remote machine
Next
From: Nick Dro
Date:
Subject: [GENERAL] Build in function to verify email addresses