[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Re: [GENERAL] expanded auto and header linestyle double
From: Pavel Stehule <pavel.stehule () gmail ! com>
Date: 2017-11-16 20:46:22
Message-ID: CAFj8pRAzS1=JfY0vQCm6r5473eV3bXvRynvAXcWrHF9hiM86BQ () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (text/plain)]
2017-11-16 21:16 GMT+01:00 Matt Zagrabelny <mzagrabe@d.umn.edu>:
> Thanks for the reply, Pavel!
>
> On Thu, Nov 16, 2017 at 1:01 AM, Pavel Stehule <pavel.stehule@gmail.com>
> wrote:
>
>> 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
>>
>>
> 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
>
[Attachment #3 (text/html)]
<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">2017-11-16 \
21:16 GMT+01:00 Matt Zagrabelny <span dir="ltr"><<a \
href="mailto:mzagrabe@d.umn.edu" \
target="_blank">mzagrabe@d.umn.edu</a>></span>:<br><blockquote class="gmail_quote" \
style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div \
dir="ltr">Thanks for the reply, Pavel!<br><div class="gmail_extra"><br><div \
class="gmail_quote">On Thu, Nov 16, 2017 at 1:01 AM, Pavel Stehule <span \
dir="ltr"><<a href="mailto:pavel.stehule@gmail.com" \
target="_blank">pavel.stehule@gmail.com</a>></span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hi<br><div><div \
class="gmail_extra"><br><div class="gmail_quote"><div><div \
class="m_6990004183439808570gmail-h5">2017-11-15 23:37 GMT+01:00 Matt Zagrabelny \
<span dir="ltr"><<a href="mailto:mzagrabe@d.umn.edu" \
target="_blank">mzagrabe@d.umn.edu</a>></span>:<br><blockquote class="gmail_quote" \
style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><div \
dir="ltr"><div>Greetings,</div><div><br></div><div>Using PG \
10.1.</div><div><br></div><div>In my .psqlrc I have:</div><div><br></div><div>\x \
auto<br></div><div>\pset linestyle 'unicode'<br></div><div><div>\pset \
unicode_header_linestyle double</div></div><div><br></div><div>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:</div><div><br></div><div>% select * from \
artist;<br></div><div>─[ RECORD 1 \
]─────────────────────────<br></div><div><div>artistid \
│ 1</div><div>name │ AC/DC</div><div>═[ RECORD 2 \
]═════════════════════════</div><div>artistid \
│ 2</div><div>name │ Accept</div><div>═[ RECORD 3 \
]═════════════════════════</div><div>artistid \
│ 3</div><div>name │ Aerosmith</div><div>═[ RECORD 4 \
]═════════════════════════</div><div>artistid \
│ 4</div><div>name │ Alanis Morissette</div><div>═[ RECORD 5 \
]═════════════════════════</div><div>artistid \
│ 5</div></div><div><br></div><div>I would like to have the initial "RECORD \
1" line have the same "double" linestyle as the other \
records.</div><div><br></div><div>Am I missing a config \
item?</div></div></blockquote><div><br></div></div></div><div>yes - it is border \
line</div><div><br></div><div>use \pset border \
2</div><div><br></div></div></div></div></div></blockquote><div><br></div><div>Hmmm.... \
I didn't use the "border" setting.</div><div> </div><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div><div class="gmail_extra"><div \
class="gmail_quote"><div></div><div>and you understand</div><div><br></div><div>you \
are missing</div><div><br></div><div>\pset unicode_border_linestyle \
double</div></div></div></div></div></blockquote><div><br></div><div>But I did use \
the above setting.</div><div><br>So my .psqlrc looks \
like:</div><div><br></div><div><div>\pset linestyle 'unicode'</div><div>\pset \
unicode_border_linestyle double</div><div>\pset unicode_header_linestyle \
double</div><div><br></div><div><div>═[ RECORD 1 \
]════════════════</div><div>artistid │ \
1</div><div>name │ AC/DC</div><div>═[ RECORD 2 \
]════════════════</div><div>artistid │ \
2</div><div>name │ Accept</div><div>═[ RECORD 3 \
]════════════════</div><div>artistid │ \
3</div><div>name │ Aerosmith</div><div><br></div></div><div>Thanks for \
helping me get it corrected.</div><div><br></div><div>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".</div></div></div></div></div></blockquote><div><br></div><div>There \
is some simplification - this line is header and together border. It has sense when \
you use border 2</div><div><br></div><div>Regards</div><div><br></div><div>Pavel</div><div><br></div><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div dir="ltr"><div class="gmail_extra"><div \
class="gmail_quote"><div><div><br></div><div>Cheers!</div><span class="HOEnZb"><font \
color="#888888"><div><br></div><div>-m</div></font></span></div></div></div></div> \
</blockquote></div><br></div></div>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic