Thanks for the reply, Pavel!
On Thu, Nov 16, 2017 at 1:01 AM, Pavel Stehule <pavel.stehule@xxxxxxxxx> wrote:
So my .psqlrc looks like:
Hi2017-11-15 23:37 GMT+01:00 Matt Zagrabelny <mzagrabe@xxxxxxxxx>:Greetings,Using PG 10.1.In my .psqlrc I have:\x auto\pset linestyle 'unicode'\pset unicode_header_linestyle doubleand 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 │ 1name │ AC/DC═[ RECORD 2 ]═════════════════════════artistid │ 2name │ Accept═[ RECORD 3 ]═════════════════════════artistid │ 3name │ Aerosmith═[ RECORD 4 ]═════════════════════════artistid │ 4name │ Alanis Morissette═[ RECORD 5 ]═════════════════════════artistid │ 5I 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 lineuse \pset border 2
Hmmm.... I didn't use the "border" setting.
and you understandyou 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
