typescript

text/plain

Filename: typescript
Type: text/plain
Part: 1
Message: Re: Unicode UTF-8 table formatting for psql text output
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