test.txt
text/plain
Filename: test.txt
Type: text/plain
Part: 2
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)