postgres=***# \pset
Border style (border) is 2.
Target width (columns) is 20.
Expanded display (expanded) is on.
Field separator (fieldsep) is "|".
Default footer (footer) is on.
Output format (format) is wrapped.
Line style (linestyle) is unicode.
Null display (null) is "".
Locale-adjusted numeric output (numericlocale) is off.
Pager (pager) usage is off.
Record separator (recordsep) is <newline>.
Table attributes (tableattr) unset.
Title (title) unset.
Tuples only (tuples_only) is off.

postgres=***# select array_to_string(array_agg(repeat('x',n)),E'\n') as "x
y",  array_to_string(array_agg(repeat('yy',10-n)),E'\n') as "x
y
z" from (select generate_series(1,10)) as t(n);

┌─[ RECORD 1 ]─────┐
│ x │ x            │
│ y │ xx           │
│   │ xxx          │
│   │ xxxx         │
│   │ xxxxx        │
│   │ xxxxxx       │
│   │ xxxxxxx      │
│   │ xxxxxxxx     │
│   │ xxxxxxxxx    │
│   │ xxxxxxxxxx   │
│ x │ yyyyyyyyyyyy │
│   │ yyyyyy       │
│ y │ yyyyyyyyyyyy │
│   │ yyyy         │
│ z │ yyyyyyyyyyyy │
│   │ yy           │
│   │ yyyyyyyyyyyy │
│   │ yyyyyyyyyy   │
│   │ yyyyyyyy     │
│   │ yyyyyy       │
│   │ yyyy         │
│   │ yy           │
│   │              │
└───┴──────────────┘

postgres=***# \pset linestyle ascii
Line style (linestyle) is ascii.

postgres=***# select array_to_string(array_agg(repeat('x',n)),E'\n') as "x
y",  array_to_string(array_agg(repeat('yy',10-n)),E'\n') as "x
y
z" from (select generate_series(1,10)) as t(n);

+-[ RECORD 1 ]-----+
| x | x            |
| y | xx           |
|   | xxx          |
|   | xxxx         |
|   | xxxxx        |
|   | xxxxxx       |
|   | xxxxxxx      |
|   | xxxxxxxx     |
|   | xxxxxxxxx    |
|   | xxxxxxxxxx   |
| x | yyyyyyyyyyyy |
|   | yyyyyy       |
| y | yyyyyyyyyyyy |
|   | yyyy         |
| z | yyyyyyyyyyyy |
|   | yy           |
|   | yyyyyyyyyyyy |
|   | yyyyyyyyyy   |
|   | yyyyyyyy     |
|   | yyyyyy       |
|   | yyyy         |
|   | yy           |
|   |              |
+---+--------------+

postgres=***# \pset columns 30
Target width (columns) is 30.

postgres=***# \pset linestyle unicode
Line style (linestyle) is unicode.

postgres=***# \pset columns 30
Target width (columns) is 30.

postgres=***# \pset expanded off
Expanded display (expanded) is off.

postgres=***# select array_to_string(array_agg(repeat('x',n)),E'\n') as "x
y",  array_to_string(array_agg(repeat('yy',10-n)),E'\n') as "x
y
z" from (select generate_series(1,10)) as t(n);

┌───────────┬────────────────┐
│     x    ↵│       x       ↵│
│     y     │       y       ↵│
│           │       z        │
├───────────┼────────────────┤
│ x        ↵│ yyyyyyyyyyyyyy…│
│ xx       ↵│…yyyy          ↵│
│ xxx      ↵│ yyyyyyyyyyyyyy…│
│ xxxx     ↵│…yy            ↵│
│ xxxxx    ↵│ yyyyyyyyyyyyyy↵│
│ xxxxxx   ↵│ yyyyyyyyyyyy  ↵│
│ xxxxxxx  ↵│ yyyyyyyyyy    ↵│
│ xxxxxxxx ↵│ yyyyyyyy      ↵│
│ xxxxxxxxx↵│ yyyyyy        ↵│
│ xxxxxxxxx…│ yyyy          ↵│
│…x         │ yy            ↵│
│           │                │
└───────────┴────────────────┘
(1 row)



postgres=***# \pset linestyle ascii
Line style (linestyle) is ascii.

postgres=***# select array_to_string(array_agg(repeat('x',n)),E'\n') as "x
y",  array_to_string(array_agg(repeat('yy',10-n)),E'\n') as "x
y
z" from (select generate_series(1,10)) as t(n);

+-----------+----------------+
|     x    +|       x       +|
|     y     |       y       +|
|           |       z        |
+-----------+----------------+
| x        +| yyyyyyyyyyyyyy.|
| xx       +|.yyyy          +|
| xxx      +| yyyyyyyyyyyyyy.|
| xxxx     +|.yy            +|
| xxxxx    +| yyyyyyyyyyyyyy+|
| xxxxxx   +| yyyyyyyyyyyy  +|
| xxxxxxx  +| yyyyyyyyyy    +|
| xxxxxxxx +| yyyyyyyy      +|
| xxxxxxxxx+| yyyyyy        +|
| xxxxxxxxx.| yyyy          +|
|.x         | yy            +|
|           |                |
+-----------+----------------+