Re: [GENERAL] expanded auto and header linestyle double
2017-11-16 21:16 GMT+01:00 Matt Zagrabelny : > Thanks for the reply, Pavel! > > On Thu, Nov 16, 2017 at 1:01 AM, Pavel Stehule > wrote: > >> Hi >> >> 2017-11-15 23:37 GMT+01:00 Matt Zagrabelny : >> >>> 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 >
Re: [GENERAL] expanded auto and header linestyle double
Thanks for the reply, Pavel! On Thu, Nov 16, 2017 at 1:01 AM, Pavel Stehule wrote: > Hi > > 2017-11-15 23:37 GMT+01:00 Matt Zagrabelny : > >> 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
Re: [GENERAL] expanded auto and header linestyle double
Hi 2017-11-15 23:37 GMT+01:00 Matt Zagrabelny : > 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 >
