stark=# select array_to_string(array_agg(repeat('x',x)),E'\n') as "x y z" from generate_series(1,20) as x(x); ┌─[ RECORD 1 ]─────┐ │ x↵│ x ↵│ │ y↵│ xx ↵│ │ z │ xxx ↵│ │ │ xxxx ↵│ │ │ xxxxx ↵│ │ │ xxxxxx ↵│ │ │ xxxxxxx ↵│ │ │ xxxxxxxx ↵│ │ │ xxxxxxxxx ↵│ │ │ xxxxxxxxxx ↵│ │ │ xxxxxxxxxxx ↵│ │ │ xxxxxxxxxxxx↵│ │ │ xxxxxxxxxxxx…│ │ │…x ↵│ │ │ xxxxxxxxxxxx…│ │ │…xx ↵│ │ │ xxxxxxxxxxxx…│ │ │…xxx ↵│ │ │ xxxxxxxxxxxx…│ │ │…xxxx ↵│ │ │ xxxxxxxxxxxx…│ │ │…xxxxx ↵│ │ │ xxxxxxxxxxxx…│ │ │…xxxxxx ↵│ │ │ xxxxxxxxxxxx…│ │ │…xxxxxxx ↵│ │ │ xxxxxxxxxxxx…│ │ │…xxxxxxxx │ └───┴──────────────┘ stark=# \pset linestyle ascii Line style (linestyle) is ascii. stark=# select array_to_string(array_agg(repeat('x',x)),E'\n') as "x y z" from generate_series(1,20) as x(x); stark"***# stark"***# stark-***# +-[ RECORD 1 ]-----+ | x+| x +| | y+| xx +| | z | xxx +| | | xxxx +| | | xxxxx +| | | xxxxxx +| | | xxxxxxx +| | | xxxxxxxx +| | | xxxxxxxxx +| | | xxxxxxxxxx +| | | xxxxxxxxxxx +| | | xxxxxxxxxxxx+| | | xxxxxxxxxxxx.| | |.x +| | | xxxxxxxxxxxx.| | |.xx +| | | xxxxxxxxxxxx.| | |.xxx +| | | xxxxxxxxxxxx.| | |.xxxx +| | | xxxxxxxxxxxx.| | |.xxxxx +| | | xxxxxxxxxxxx.| | |.xxxxxx +| | | xxxxxxxxxxxx.| | |.xxxxxxx +| | | xxxxxxxxxxxx.| | |.xxxxxxxx | +---+--------------+ stark=# \pset linestyle old-ascii Line style (linestyle) is old-ascii. stark=# select array_to_string(array_agg(repeat('x',x)),E'\n') as "x y z" from generate_series(1,20) as x(x); stark"# stark"# stark-# +-[ RECORD 1 ]-----+ | x | x | | y | xx | | z | xxx | | | xxxx | | | xxxxx | | | xxxxxx | | | xxxxxxx | | | xxxxxxxx | | | xxxxxxxxx | | | xxxxxxxxxx | | | xxxxxxxxxxx | | | xxxxxxxxxxxx | | | xxxxxxxxxxxx | | | x | | | xxxxxxxxxxxx | | | xx | | | xxxxxxxxxxxx | | | xxx | | | xxxxxxxxxxxx | | | xxxx | | | xxxxxxxxxxxx | | | xxxxx | | | xxxxxxxxxxxx | | | xxxxxx | | | xxxxxxxxxxxx | | | xxxxxxx | | | xxxxxxxxxxxx | | | xxxxxxxx | +---+--------------+ stark=# \pset expanded off Expanded display (expanded) is off. stark=# \pset columns 40 Target width (columns) is 40. stark=# select array_to_string(array_agg(repeat('x',x)),E'\n') as "x y z",array_to_string(array_agg(repeat('x',20-x)),E'\n') as "x y z" from generate_series(1,25) as x(x); +--------------------+-----------------+ | x | x | |+ y |+ y | |+ z |+ z | +--------------------+-----------------+ | x | xxxxxxxxxxxxxxx | | xx ; xxxx | | xxx : xxxxxxxxxxxxxxx | | xxxx ; xxx | | xxxxx : xxxxxxxxxxxxxxx | | xxxxxx ; xx | | xxxxxxx : xxxxxxxxxxxxxxx | | xxxxxxxx ; x | | xxxxxxxxx : xxxxxxxxxxxxxxx | | xxxxxxxxxx : xxxxxxxxxxxxxx | | xxxxxxxxxxx : xxxxxxxxxxxxx | | xxxxxxxxxxxx : xxxxxxxxxxxx | | xxxxxxxxxxxxx : xxxxxxxxxxx | | xxxxxxxxxxxxxx : xxxxxxxxxx | | xxxxxxxxxxxxxxx : xxxxxxxxx | | xxxxxxxxxxxxxxxx : xxxxxxxx | | xxxxxxxxxxxxxxxxx : xxxxxxx | | xxxxxxxxxxxxxxxxxx : xxxxxx | | xxxxxxxxxxxxxxxxxx : xxxxx | | x : xxxx | | xxxxxxxxxxxxxxxxxx : xxx | | xx : xx | | xxxxxxxxxxxxxxxxxx : x | | xxx : | | xxxxxxxxxxxxxxxxxx : | | xxxx : | | xxxxxxxxxxxxxxxxxx : | | xxxxx : | | xxxxxxxxxxxxxxxxxx : | | xxxxxx | | xxxxxxxxxxxxxxxxxx | | xxxxxxx | +--------------------+-----------------+ (1 row)