expanded auto and header linestyle double

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 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".

Cheers!

-m

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