2017-11-16 21:16 GMT+01:00 Matt Zagrabelny <mzagr...@d.umn.edu>: > Thanks for the reply, Pavel! > > On Thu, Nov 16, 2017 at 1:01 AM, Pavel Stehule <pavel.steh...@gmail.com> > wrote: > >> Hi >> >> 2017-11-15 23:37 GMT+01:00 Matt Zagrabelny <mzagr...@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 >> >> > 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 >