rleigh=# \pset linestyle ascii-old Line style is ascii-old. rleigh=# \i test.sql Pager usage is off. Border style is 0. Lorem num ipsum + dolor + ----------- --- sit amet, 5 consectetur adipisicing elit (1 row) Border style is 1. Lorem | num + ipsum |+ + dolor |+ -------------+----- sit amet, | 5 consectetur adipisicing elit (1 row) Border style is 2. +-------------+-----+ | Lorem | num | |+ ipsum |+ | |+ dolor |+ | +-------------+-----+ | sit amet, | 5 | | consectetur | | adipisicing | | elit | +-------------+-----+ (1 row) Output format is wrapped. Border style is 0. num Lorem ipsum dolor --- ----------------------------------------------------------------------------------- 5 Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor inc ididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exe rcitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit (1 row) Border style is 1. num | Lorem ipsum dolor -----+---------------------------------------------------------------------------------- 5 | Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor ; incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostr ; ud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. : Duis : aute : irure : dolor : in : reprehenderit (1 row) Border style is 2. +-----+--------------------------------------------------------------------------------+ | num | Lorem ipsum dolor | +-----+--------------------------------------------------------------------------------+ | 5 | Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempo | | ; r incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis n | | ; ostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. | | : Duis | | : aute | | : irure | | : dolor | | : in | | : reprehenderit | +-----+--------------------------------------------------------------------------------+ (1 row) rleigh=# \pset linestyle ascii Line style is ascii. rleigh=# \i test.sql Pager usage is off. Border style is 0. Lorem num ipsum dolor ----------- --- sit amet, + 5 consectetur+ adipisicing+ elit (1 row) Border style is 1. Lorem +| num ipsum +| dolor | -------------+----- sit amet, +| 5 consectetur+| adipisicing+| elit | (1 row) Border style is 2. +-------------+-----+ | Lorem +| num | | ipsum +| | | dolor | | +-------------+-----+ | sit amet, +| 5 | | consectetur+| | | adipisicing+| | | elit | | +-------------+-----+ (1 row) Output format is wrapped. Border style is 0. num Lorem ipsum dolor --- ----------------------------------------------------------------------------------- 5 Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor inc. ididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exe. rcitation ullamco laboris nisi ut aliquip ex ea commodo consequat. + Duis + aute + irure + dolor + in + reprehenderit (1 row) Border style is 1. num | Lorem ipsum dolor -----+---------------------------------------------------------------------------------- 5 | Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor . |.incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostr. |.ud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. + | Duis + | aute + | irure + | dolor + | in + | reprehenderit (1 row) Border style is 2. +-----+--------------------------------------------------------------------------------+ | num | Lorem ipsum dolor | +-----+--------------------------------------------------------------------------------+ | 5 | Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempo.| | |.r incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis n.| | |.ostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. +| | | Duis +| | | aute +| | | irure +| | | dolor +| | | in +| | | reprehenderit | +-----+--------------------------------------------------------------------------------+ (1 row) rleigh=# \pset linestyle unicode Line style is unicode. rleigh=# \i test.sql Pager usage is off. Border style is 0. Lorem ↵num ipsum ↵ dolor ─────────── ─── sit amet, ↵ 5 consectetur↵ adipisicing↵ elit (1 row) Border style is 1. Lorem ↵│ num ipsum ↵│ dolor │ ─────────────┼───── sit amet, ↵│ 5 consectetur↵│ adipisicing↵│ elit │ (1 row) Border style is 2. ┌─────────────┬─────┐ │ Lorem ↵│ num │ │ ipsum ↵│ │ │ dolor │ │ ├─────────────┼─────┤ │ sit amet, ↵│ 5 │ │ consectetur↵│ │ │ adipisicing↵│ │ │ elit │ │ └─────────────┴─────┘ (1 row) Output format is wrapped. Border style is 0. num Lorem ipsum dolor ─── ─────────────────────────────────────────────────────────────────────────────────── 5 Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor inc… ididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exe… rcitation ullamco laboris nisi ut aliquip ex ea commodo consequat. ↵ Duis ↵ aute ↵ irure ↵ dolor ↵ in ↵ reprehenderit (1 row) Border style is 1. num │ Lorem ipsum dolor ─────┼────────────────────────────────────────────────────────────────────────────────── 5 │ Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor … │…incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostr… │…ud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. ↵ │ Duis ↵ │ aute ↵ │ irure ↵ │ dolor ↵ │ in ↵ │ reprehenderit (1 row) Border style is 2. ┌─────┬────────────────────────────────────────────────────────────────────────────────┐ │ num │ Lorem ipsum dolor │ ├─────┼────────────────────────────────────────────────────────────────────────────────┤ │ 5 │ Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempo…│ │ │…r incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis n…│ │ │…ostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. ↵│ │ │ Duis ↵│ │ │ aute ↵│ │ │ irure ↵│ │ │ dolor ↵│ │ │ in ↵│ │ │ reprehenderit │ └─────┴────────────────────────────────────────────────────────────────────────────────┘ (1 row) rleigh=# \pset linestyle invalid \pset: allowed line styles are ascii, ascii-old, unicode