psql from pg 8.4.1 ------------------ 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 tem por incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, qu is nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo conseq uat. 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 ve ; niam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea co ; mmodo 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 eiusm | | ; od tempor incididunt ut labore et dolore magna aliqua. Ut enim ad mini | | ; m veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex | | ; ea commodo consequat. | | : Duis | | : aute | | : irure | | : dolor | | : in | | : reprehenderit | +-----+------------------------------------------------------------------------+ (1 row) psql from current git + patch (UTF-8) ------------------------------------- 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 te… mpor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, … quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo con… sequat. … 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 ve… │…niam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea co… │…mmodo 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 eiusm…│ │ │…od tempor incididunt ut labore et dolore magna aliqua. Ut enim ad mini…│ │ │…m veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex…│ │ │… ea commodo consequat. …│ │ │ Duis ↵│ │ │ aute ↵│ │ │ irure ↵│ │ │ dolor ↵│ │ │ in ↵│ │ │ reprehenderit │ └─────┴────────────────────────────────────────────────────────────────────────┘ (1 row) psql from current git + patch (SQL_ASCII) ----------------------------------------- rleigh=# \encoding SQL_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 te. mpor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, . quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo con. sequat. . 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 ve. |.niam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea co. |.mmodo 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 eiusm.| | |.od tempor incididunt ut labore et dolore magna aliqua. Ut enim ad mini.| | |.m veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex.| | |. ea commodo consequat. .| | | Duis +| | | aute +| | | irure +| | | dolor +| | | in +| | | reprehenderit | +-----+------------------------------------------------------------------------+ (1 row)