]> granicus.if.org Git - postgresql/blob - src/test/regress/expected/psql.out
projects / postgresql / blob
? search:


edcc414630c137f063858f2fe0f5f67a521da106
[postgresql] / src / test / regress / expected / psql.out
1 --
2 -- Tests for psql features that aren't closely connected to any
3 -- specific server features
4 --
5 -- \gset
6 select 10 as test01, 20 as test02, 'Hello' as test03 \gset pref01_
7 \echo :pref01_test01 :pref01_test02 :pref01_test03
8 10 20 Hello
9 -- should fail: bad variable name
10 select 10 as "bad name"
11 \gset
12 could not set variable "bad name"
13 -- multiple backslash commands in one line
14 select 1 as x, 2 as y \gset pref01_ \\ \echo :pref01_x
15 1
16 select 3 as x, 4 as y \gset pref01_ \echo :pref01_x \echo :pref01_y
17 3
18 4
19 select 5 as x, 6 as y \gset pref01_ \\ \g \echo :pref01_x :pref01_y
20  x | y 
21 ---+---
22  5 | 6
23 (1 row)
24
25 5 6
26 select 7 as x, 8 as y \g \gset pref01_ \echo :pref01_x :pref01_y
27  x | y 
28 ---+---
29  7 | 8
30 (1 row)
31
32 7 8
33 -- NULL should unset the variable
34 \set var2 xyz
35 select 1 as var1, NULL as var2, 3 as var3 \gset
36 \echo :var1 :var2 :var3
37 1 :var2 3
38 -- \gset requires just one tuple
39 select 10 as test01, 20 as test02 from generate_series(1,3) \gset
40 more than one row returned for \gset
41 select 10 as test01, 20 as test02 from generate_series(1,0) \gset
42 no rows returned for \gset
43 -- \gset should work in FETCH_COUNT mode too
44 \set FETCH_COUNT 1
45 select 1 as x, 2 as y \gset pref01_ \\ \echo :pref01_x
46 1
47 select 3 as x, 4 as y \gset pref01_ \echo :pref01_x \echo :pref01_y
48 3
49 4
50 select 10 as test01, 20 as test02 from generate_series(1,3) \gset
51 more than one row returned for \gset
52 select 10 as test01, 20 as test02 from generate_series(1,0) \gset
53 no rows returned for \gset
54 \unset FETCH_COUNT
55 -- \gexec
56 create temporary table gexec_test(a int, b text, c date, d float);
57 select format('create index on gexec_test(%I)', attname)
58 from pg_attribute
59 where attrelid = 'gexec_test'::regclass and attnum > 0
60 order by attnum
61 \gexec
62 create index on gexec_test(a)
63 create index on gexec_test(b)
64 create index on gexec_test(c)
65 create index on gexec_test(d)
66 -- \gexec should work in FETCH_COUNT mode too
67 -- (though the fetch limit applies to the executed queries not the meta query)
68 \set FETCH_COUNT 1
69 select 'select 1 as ones', 'select x.y, x.y*2 as double from generate_series(1,4) as x(y)'
70 union all
71 select 'drop table gexec_test', NULL
72 union all
73 select 'drop table gexec_test', 'select ''2000-01-01''::date as party_over'
74 \gexec
75 select 1 as ones
76  ones 
77 ------
78     1
79 (1 row)
80
81 select x.y, x.y*2 as double from generate_series(1,4) as x(y)
82  y | double 
83 ---+--------
84  1 |      2
85  2 |      4
86  3 |      6
87  4 |      8
88 (4 rows)
89
90 drop table gexec_test
91 drop table gexec_test
92 ERROR:  table "gexec_test" does not exist
93 select '2000-01-01'::date as party_over
94  party_over 
95 ------------
96  01-01-2000
97 (1 row)
98
99 \unset FETCH_COUNT
100 -- show all pset options
101 \pset
102 border                   1
103 columns                  0
104 expanded                 off
105 fieldsep                 '|'
106 fieldsep_zero            off
107 footer                   on
108 format                   aligned
109 linestyle                ascii
110 null                     ''
111 numericlocale            off
112 pager                    1
113 pager_min_lines          0
114 recordsep                '\n'
115 recordsep_zero           off
116 tableattr                
117 title                    
118 tuples_only              off
119 unicode_border_linestyle single
120 unicode_column_linestyle single
121 unicode_header_linestyle single
122 -- test multi-line headers, wrapping, and newline indicators
123 prepare q as select array_to_string(array_agg(repeat('x',2*n)),E'\n') as "ab
124
125 c", array_to_string(array_agg(repeat('y',20-2*n)),E'\n') as "a
126 bc" from generate_series(1,10) as n(n) group by n>1 ;
127 \pset linestyle ascii
128 \pset expanded off
129 \pset columns 40
130 \pset border 0
131 \pset format unaligned
132 execute q;
133 ab
134
135 c|a
136 bc
137 xx|yyyyyyyyyyyyyyyyyy
138 xxxx
139 xxxxxx
140 xxxxxxxx
141 xxxxxxxxxx
142 xxxxxxxxxxxx
143 xxxxxxxxxxxxxx
144 xxxxxxxxxxxxxxxx
145 xxxxxxxxxxxxxxxxxx
146 xxxxxxxxxxxxxxxxxxxx|yyyyyyyyyyyyyyyy
147 yyyyyyyyyyyyyy
148 yyyyyyyyyyyy
149 yyyyyyyyyy
150 yyyyyyyy
151 yyyyyy
152 yyyy
153 yy
154
155 (2 rows)
156 \pset format aligned
157 execute q;
158          ab         +        a         +
159                     +        bc         
160          c                              
161 -------------------- ------------------
162 xx                   yyyyyyyyyyyyyyyyyy
163 xxxx                +yyyyyyyyyyyyyyyy  +
164 xxxxxx              +yyyyyyyyyyyyyy    +
165 xxxxxxxx            +yyyyyyyyyyyy      +
166 xxxxxxxxxx          +yyyyyyyyyy        +
167 xxxxxxxxxxxx        +yyyyyyyy          +
168 xxxxxxxxxxxxxx      +yyyyyy            +
169 xxxxxxxxxxxxxxxx    +yyyy              +
170 xxxxxxxxxxxxxxxxxx  +yy                +
171 xxxxxxxxxxxxxxxxxxxx 
172 (2 rows)
173
174 \pset format wrapped
175 execute q;
176          ab         +        a         +
177                     +        bc         
178          c                              
179 -------------------- ------------------
180 xx                   yyyyyyyyyyyyyyyyyy
181 xxxx                +yyyyyyyyyyyyyyyy  +
182 xxxxxx              +yyyyyyyyyyyyyy    +
183 xxxxxxxx            +yyyyyyyyyyyy      +
184 xxxxxxxxxx          +yyyyyyyyyy        +
185 xxxxxxxxxxxx        +yyyyyyyy          +
186 xxxxxxxxxxxxxx      +yyyyyy            +
187 xxxxxxxxxxxxxxxx    +yyyy              +
188 xxxxxxxxxxxxxxxxxx  +yy                +
189 xxxxxxxxxxxxxxxxxxxx 
190 (2 rows)
191
192 \pset border 1
193 \pset format unaligned
194 execute q;
195 ab
196
197 c|a
198 bc
199 xx|yyyyyyyyyyyyyyyyyy
200 xxxx
201 xxxxxx
202 xxxxxxxx
203 xxxxxxxxxx
204 xxxxxxxxxxxx
205 xxxxxxxxxxxxxx
206 xxxxxxxxxxxxxxxx
207 xxxxxxxxxxxxxxxxxx
208 xxxxxxxxxxxxxxxxxxxx|yyyyyyyyyyyyyyyy
209 yyyyyyyyyyyyyy
210 yyyyyyyyyyyy
211 yyyyyyyyyy
212 yyyyyyyy
213 yyyyyy
214 yyyy
215 yy
216
217 (2 rows)
218 \pset format aligned
219 execute q;
220           ab         +|         a         +
221                      +|         bc         
222           c           |                    
223 ----------------------+--------------------
224  xx                   | yyyyyyyyyyyyyyyyyy
225  xxxx                +| yyyyyyyyyyyyyyyy  +
226  xxxxxx              +| yyyyyyyyyyyyyy    +
227  xxxxxxxx            +| yyyyyyyyyyyy      +
228  xxxxxxxxxx          +| yyyyyyyyyy        +
229  xxxxxxxxxxxx        +| yyyyyyyy          +
230  xxxxxxxxxxxxxx      +| yyyyyy            +
231  xxxxxxxxxxxxxxxx    +| yyyy              +
232  xxxxxxxxxxxxxxxxxx  +| yy                +
233  xxxxxxxxxxxxxxxxxxxx | 
234 (2 rows)
235
236 \pset format wrapped
237 execute q;
238         ab        +|         a         +
239                   +|         bc         
240          c         |                    
241 -------------------+--------------------
242  xx                | yyyyyyyyyyyyyyyyyy
243  xxxx             +| yyyyyyyyyyyyyyyy  +
244  xxxxxx           +| yyyyyyyyyyyyyy    +
245  xxxxxxxx         +| yyyyyyyyyyyy      +
246  xxxxxxxxxx       +| yyyyyyyyyy        +
247  xxxxxxxxxxxx     +| yyyyyyyy          +
248  xxxxxxxxxxxxxx   +| yyyyyy            +
249  xxxxxxxxxxxxxxxx +| yyyy              +
250  xxxxxxxxxxxxxxxxx.| yy                +
251 .x                +| 
252  xxxxxxxxxxxxxxxxx.| 
253 .xxx               | 
254 (2 rows)
255
256 \pset border 2
257 \pset format unaligned
258 execute q;
259 ab
260
261 c|a
262 bc
263 xx|yyyyyyyyyyyyyyyyyy
264 xxxx
265 xxxxxx
266 xxxxxxxx
267 xxxxxxxxxx
268 xxxxxxxxxxxx
269 xxxxxxxxxxxxxx
270 xxxxxxxxxxxxxxxx
271 xxxxxxxxxxxxxxxxxx
272 xxxxxxxxxxxxxxxxxxxx|yyyyyyyyyyyyyyyy
273 yyyyyyyyyyyyyy
274 yyyyyyyyyyyy
275 yyyyyyyyyy
276 yyyyyyyy
277 yyyyyy
278 yyyy
279 yy
280
281 (2 rows)
282 \pset format aligned
283 execute q;
284 +----------------------+--------------------+
285 |          ab         +|         a         +|
286 |                     +|         bc         |
287 |          c           |                    |
288 +----------------------+--------------------+
289 | xx                   | yyyyyyyyyyyyyyyyyy |
290 | xxxx                +| yyyyyyyyyyyyyyyy  +|
291 | xxxxxx              +| yyyyyyyyyyyyyy    +|
292 | xxxxxxxx            +| yyyyyyyyyyyy      +|
293 | xxxxxxxxxx          +| yyyyyyyyyy        +|
294 | xxxxxxxxxxxx        +| yyyyyyyy          +|
295 | xxxxxxxxxxxxxx      +| yyyyyy            +|
296 | xxxxxxxxxxxxxxxx    +| yyyy              +|
297 | xxxxxxxxxxxxxxxxxx  +| yy                +|
298 | xxxxxxxxxxxxxxxxxxxx |                    |
299 +----------------------+--------------------+
300 (2 rows)
301
302 \pset format wrapped
303 execute q;
304 +-----------------+--------------------+
305 |       ab       +|         a         +|
306 |                +|         bc         |
307 |        c        |                    |
308 +-----------------+--------------------+
309 | xx              | yyyyyyyyyyyyyyyyyy |
310 | xxxx           +| yyyyyyyyyyyyyyyy  +|
311 | xxxxxx         +| yyyyyyyyyyyyyy    +|
312 | xxxxxxxx       +| yyyyyyyyyyyy      +|
313 | xxxxxxxxxx     +| yyyyyyyyyy        +|
314 | xxxxxxxxxxxx   +| yyyyyyyy          +|
315 | xxxxxxxxxxxxxx +| yyyyyy            +|
316 | xxxxxxxxxxxxxxx.| yyyy              +|
317 |.x              +| yy                +|
318 | xxxxxxxxxxxxxxx.|                    |
319 |.xxx            +|                    |
320 | xxxxxxxxxxxxxxx.|                    |
321 |.xxxxx           |                    |
322 +-----------------+--------------------+
323 (2 rows)
324
325 \pset expanded on
326 \pset columns 20
327 \pset border 0
328 \pset format unaligned
329 execute q;
330 ab
331
332 c|xx
333 a
334 bc|yyyyyyyyyyyyyyyyyy
335
336 ab
337
338 c|xxxx
339 xxxxxx
340 xxxxxxxx
341 xxxxxxxxxx
342 xxxxxxxxxxxx
343 xxxxxxxxxxxxxx
344 xxxxxxxxxxxxxxxx
345 xxxxxxxxxxxxxxxxxx
346 xxxxxxxxxxxxxxxxxxxx
347 a
348 bc|yyyyyyyyyyyyyyyy
349 yyyyyyyyyyyyyy
350 yyyyyyyyyyyy
351 yyyyyyyyyy
352 yyyyyyyy
353 yyyyyy
354 yyyy
355 yy
356
357 \pset format aligned
358 execute q;
359 * Record 1            
360 ab+ xx
361   +
362 c  
363 a + yyyyyyyyyyyyyyyyyy
364 bc 
365 * Record 2            
366 ab+ xxxx                +
367   + xxxxxx              +
368 c   xxxxxxxx            +
369     xxxxxxxxxx          +
370     xxxxxxxxxxxx        +
371     xxxxxxxxxxxxxx      +
372     xxxxxxxxxxxxxxxx    +
373     xxxxxxxxxxxxxxxxxx  +
374     xxxxxxxxxxxxxxxxxxxx
375 a + yyyyyyyyyyyyyyyy    +
376 bc  yyyyyyyyyyyyyy      +
377     yyyyyyyyyyyy        +
378     yyyyyyyyyy          +
379     yyyyyyyy            +
380     yyyyyy              +
381     yyyy                +
382     yy                  +
383     
384
385 \pset format wrapped
386 execute q;
387 * Record 1       
388 ab+ xx
389   +
390 c  
391 a + yyyyyyyyyyyyyyy.
392 bc .yyy
393 * Record 2       
394 ab+ xxxx           +
395   + xxxxxx         +
396 c   xxxxxxxx       +
397     xxxxxxxxxx     +
398     xxxxxxxxxxxx   +
399     xxxxxxxxxxxxxx +
400     xxxxxxxxxxxxxxx.
401    .x              +
402     xxxxxxxxxxxxxxx.
403    .xxx            +
404     xxxxxxxxxxxxxxx.
405    .xxxxx
406 a + yyyyyyyyyyyyyyy.
407 bc .y              +
408     yyyyyyyyyyyyyy +
409     yyyyyyyyyyyy   +
410     yyyyyyyyyy     +
411     yyyyyyyy       +
412     yyyyyy         +
413     yyyy           +
414     yy             +
415     
416
417 \pset border 1
418 \pset format unaligned
419 execute q;
420 ab
421
422 c|xx
423 a
424 bc|yyyyyyyyyyyyyyyyyy
425
426 ab
427
428 c|xxxx
429 xxxxxx
430 xxxxxxxx
431 xxxxxxxxxx
432 xxxxxxxxxxxx
433 xxxxxxxxxxxxxx
434 xxxxxxxxxxxxxxxx
435 xxxxxxxxxxxxxxxxxx
436 xxxxxxxxxxxxxxxxxxxx
437 a
438 bc|yyyyyyyyyyyyyyyy
439 yyyyyyyyyyyyyy
440 yyyyyyyyyyyy
441 yyyyyyyyyy
442 yyyyyyyy
443 yyyyyy
444 yyyy
445 yy
446
447 \pset format aligned
448 execute q;
449 -[ RECORD 1 ]------------
450 ab+| xx
451   +|
452 c  |
453 a +| yyyyyyyyyyyyyyyyyy
454 bc |
455 -[ RECORD 2 ]------------
456 ab+| xxxx                +
457   +| xxxxxx              +
458 c  | xxxxxxxx            +
459    | xxxxxxxxxx          +
460    | xxxxxxxxxxxx        +
461    | xxxxxxxxxxxxxx      +
462    | xxxxxxxxxxxxxxxx    +
463    | xxxxxxxxxxxxxxxxxx  +
464    | xxxxxxxxxxxxxxxxxxxx
465 a +| yyyyyyyyyyyyyyyy    +
466 bc | yyyyyyyyyyyyyy      +
467    | yyyyyyyyyyyy        +
468    | yyyyyyyyyy          +
469    | yyyyyyyy            +
470    | yyyyyy              +
471    | yyyy                +
472    | yy                  +
473    | 
474
475 \pset format wrapped
476 execute q;
477 -[ RECORD 1 ]------
478 ab+| xx
479   +|
480 c  |
481 a +| yyyyyyyyyyyyyy.
482 bc |.yyyy
483 -[ RECORD 2 ]------
484 ab+| xxxx          +
485   +| xxxxxx        +
486 c  | xxxxxxxx      +
487    | xxxxxxxxxx    +
488    | xxxxxxxxxxxx  +
489    | xxxxxxxxxxxxxx+
490    | xxxxxxxxxxxxxx.
491    |.xx            +
492    | xxxxxxxxxxxxxx.
493    |.xxxx          +
494    | xxxxxxxxxxxxxx.
495    |.xxxxxx
496 a +| yyyyyyyyyyyyyy.
497 bc |.yy            +
498    | yyyyyyyyyyyyyy+
499    | yyyyyyyyyyyy  +
500    | yyyyyyyyyy    +
501    | yyyyyyyy      +
502    | yyyyyy        +
503    | yyyy          +
504    | yy            +
505    | 
506
507 \pset border 2
508 \pset format unaligned
509 execute q;
510 ab
511
512 c|xx
513 a
514 bc|yyyyyyyyyyyyyyyyyy
515
516 ab
517
518 c|xxxx
519 xxxxxx
520 xxxxxxxx
521 xxxxxxxxxx
522 xxxxxxxxxxxx
523 xxxxxxxxxxxxxx
524 xxxxxxxxxxxxxxxx
525 xxxxxxxxxxxxxxxxxx
526 xxxxxxxxxxxxxxxxxxxx
527 a
528 bc|yyyyyyyyyyyyyyyy
529 yyyyyyyyyyyyyy
530 yyyyyyyyyyyy
531 yyyyyyyyyy
532 yyyyyyyy
533 yyyyyy
534 yyyy
535 yy
536
537 \pset format aligned
538 execute q;
539 +-[ RECORD 1 ]--------------+
540 | ab+| xx                   |
541 |   +|                      |
542 | c  |                      |
543 | a +| yyyyyyyyyyyyyyyyyy   |
544 | bc |                      |
545 +-[ RECORD 2 ]--------------+
546 | ab+| xxxx                +|
547 |   +| xxxxxx              +|
548 | c  | xxxxxxxx            +|
549 |    | xxxxxxxxxx          +|
550 |    | xxxxxxxxxxxx        +|
551 |    | xxxxxxxxxxxxxx      +|
552 |    | xxxxxxxxxxxxxxxx    +|
553 |    | xxxxxxxxxxxxxxxxxx  +|
554 |    | xxxxxxxxxxxxxxxxxxxx |
555 | a +| yyyyyyyyyyyyyyyy    +|
556 | bc | yyyyyyyyyyyyyy      +|
557 |    | yyyyyyyyyyyy        +|
558 |    | yyyyyyyyyy          +|
559 |    | yyyyyyyy            +|
560 |    | yyyyyy              +|
561 |    | yyyy                +|
562 |    | yy                  +|
563 |    |                      |
564 +----+----------------------+
565
566 \pset format wrapped
567 execute q;
568 +-[ RECORD 1 ]-----+
569 | ab+| xx          |
570 |   +|             |
571 | c  |             |
572 | a +| yyyyyyyyyyy.|
573 | bc |.yyyyyyy     |
574 +-[ RECORD 2 ]-----+
575 | ab+| xxxx       +|
576 |   +| xxxxxx     +|
577 | c  | xxxxxxxx   +|
578 |    | xxxxxxxxxx +|
579 |    | xxxxxxxxxxx.|
580 |    |.x          +|
581 |    | xxxxxxxxxxx.|
582 |    |.xxx        +|
583 |    | xxxxxxxxxxx.|
584 |    |.xxxxx      +|
585 |    | xxxxxxxxxxx.|
586 |    |.xxxxxxx    +|
587 |    | xxxxxxxxxxx.|
588 |    |.xxxxxxxxx   |
589 | a +| yyyyyyyyyyy.|
590 | bc |.yyyyy      +|
591 |    | yyyyyyyyyyy.|
592 |    |.yyy        +|
593 |    | yyyyyyyyyyy.|
594 |    |.y          +|
595 |    | yyyyyyyyyy +|
596 |    | yyyyyyyy   +|
597 |    | yyyyyy     +|
598 |    | yyyy       +|
599 |    | yy         +|
600 |    |             |
601 +----+-------------+
602
603 \pset linestyle old-ascii
604 \pset expanded off
605 \pset columns 40
606 \pset border 0
607 \pset format unaligned
608 execute q;
609 ab
610
611 c|a
612 bc
613 xx|yyyyyyyyyyyyyyyyyy
614 xxxx
615 xxxxxx
616 xxxxxxxx
617 xxxxxxxxxx
618 xxxxxxxxxxxx
619 xxxxxxxxxxxxxx
620 xxxxxxxxxxxxxxxx
621 xxxxxxxxxxxxxxxxxx
622 xxxxxxxxxxxxxxxxxxxx|yyyyyyyyyyyyyyyy
623 yyyyyyyyyyyyyy
624 yyyyyyyyyyyy
625 yyyyyyyyyy
626 yyyyyyyy
627 yyyyyy
628 yyyy
629 yy
630
631 (2 rows)
632 \pset format aligned
633 execute q;
634          ab                  a         
635                     +        bc        
636          c          +                  
637 -------------------- ------------------
638 xx                   yyyyyyyyyyyyyyyyyy
639 xxxx                 yyyyyyyyyyyyyyyy   
640 xxxxxx               yyyyyyyyyyyyyy     
641 xxxxxxxx             yyyyyyyyyyyy       
642 xxxxxxxxxx           yyyyyyyyyy         
643 xxxxxxxxxxxx         yyyyyyyy           
644 xxxxxxxxxxxxxx       yyyyyy             
645 xxxxxxxxxxxxxxxx     yyyy               
646 xxxxxxxxxxxxxxxxxx   yy                 
647 xxxxxxxxxxxxxxxxxxxx 
648 (2 rows)
649
650 \pset format wrapped
651 execute q;
652          ab                  a         
653                     +        bc        
654          c          +                  
655 -------------------- ------------------
656 xx                   yyyyyyyyyyyyyyyyyy
657 xxxx                 yyyyyyyyyyyyyyyy   
658 xxxxxx               yyyyyyyyyyyyyy     
659 xxxxxxxx             yyyyyyyyyyyy       
660 xxxxxxxxxx           yyyyyyyyyy         
661 xxxxxxxxxxxx         yyyyyyyy           
662 xxxxxxxxxxxxxx       yyyyyy             
663 xxxxxxxxxxxxxxxx     yyyy               
664 xxxxxxxxxxxxxxxxxx   yy                 
665 xxxxxxxxxxxxxxxxxxxx 
666 (2 rows)
667
668 \pset border 1
669 \pset format unaligned
670 execute q;
671 ab
672
673 c|a
674 bc
675 xx|yyyyyyyyyyyyyyyyyy
676 xxxx
677 xxxxxx
678 xxxxxxxx
679 xxxxxxxxxx
680 xxxxxxxxxxxx
681 xxxxxxxxxxxxxx
682 xxxxxxxxxxxxxxxx
683 xxxxxxxxxxxxxxxxxx
684 xxxxxxxxxxxxxxxxxxxx|yyyyyyyyyyyyyyyy
685 yyyyyyyyyyyyyy
686 yyyyyyyyyyyy
687 yyyyyyyyyy
688 yyyyyyyy
689 yyyyyy
690 yyyy
691 yy
692
693 (2 rows)
694 \pset format aligned
695 execute q;
696           ab          |         a          
697 +                     |+        bc         
698 +         c           |+                   
699 ----------------------+--------------------
700  xx                   | yyyyyyyyyyyyyyyyyy
701  xxxx                 | yyyyyyyyyyyyyyyy   
702  xxxxxx               : yyyyyyyyyyyyyy     
703  xxxxxxxx             : yyyyyyyyyyyy       
704  xxxxxxxxxx           : yyyyyyyyyy         
705  xxxxxxxxxxxx         : yyyyyyyy           
706  xxxxxxxxxxxxxx       : yyyyyy             
707  xxxxxxxxxxxxxxxx     : yyyy               
708  xxxxxxxxxxxxxxxxxx   : yy                 
709  xxxxxxxxxxxxxxxxxxxx : 
710 (2 rows)
711
712 \pset format wrapped
713 execute q;
714         ab         |         a          
715 +                  |+        bc         
716 +        c         |+                   
717 -------------------+--------------------
718  xx                | yyyyyyyyyyyyyyyyyy
719  xxxx              | yyyyyyyyyyyyyyyy   
720  xxxxxx            : yyyyyyyyyyyyyy     
721  xxxxxxxx          : yyyyyyyyyyyy       
722  xxxxxxxxxx        : yyyyyyyyyy         
723  xxxxxxxxxxxx      : yyyyyyyy           
724  xxxxxxxxxxxxxx    : yyyyyy             
725  xxxxxxxxxxxxxxxx  : yyyy               
726  xxxxxxxxxxxxxxxxx : yy                 
727  x                 : 
728  xxxxxxxxxxxxxxxxx   
729  xxx                 
730 (2 rows)
731
732 \pset border 2
733 \pset format unaligned
734 execute q;
735 ab
736
737 c|a
738 bc
739 xx|yyyyyyyyyyyyyyyyyy
740 xxxx
741 xxxxxx
742 xxxxxxxx
743 xxxxxxxxxx
744 xxxxxxxxxxxx
745 xxxxxxxxxxxxxx
746 xxxxxxxxxxxxxxxx
747 xxxxxxxxxxxxxxxxxx
748 xxxxxxxxxxxxxxxxxxxx|yyyyyyyyyyyyyyyy
749 yyyyyyyyyyyyyy
750 yyyyyyyyyyyy
751 yyyyyyyyyy
752 yyyyyyyy
753 yyyyyy
754 yyyy
755 yy
756
757 (2 rows)
758 \pset format aligned
759 execute q;
760 +----------------------+--------------------+
761 |          ab          |         a          |
762 |+                     |+        bc         |
763 |+         c           |+                   |
764 +----------------------+--------------------+
765 | xx                   | yyyyyyyyyyyyyyyyyy |
766 | xxxx                 | yyyyyyyyyyyyyyyy   |
767 | xxxxxx               : yyyyyyyyyyyyyy     |
768 | xxxxxxxx             : yyyyyyyyyyyy       |
769 | xxxxxxxxxx           : yyyyyyyyyy         |
770 | xxxxxxxxxxxx         : yyyyyyyy           |
771 | xxxxxxxxxxxxxx       : yyyyyy             |
772 | xxxxxxxxxxxxxxxx     : yyyy               |
773 | xxxxxxxxxxxxxxxxxx   : yy                 |
774 | xxxxxxxxxxxxxxxxxxxx :                    |
775 +----------------------+--------------------+
776 (2 rows)
777
778 \pset format wrapped
779 execute q;
780 +-----------------+--------------------+
781 |       ab        |         a          |
782 |+                |+        bc         |
783 |+       c        |+                   |
784 +-----------------+--------------------+
785 | xx              | yyyyyyyyyyyyyyyyyy |
786 | xxxx            | yyyyyyyyyyyyyyyy   |
787 | xxxxxx          : yyyyyyyyyyyyyy     |
788 | xxxxxxxx        : yyyyyyyyyyyy       |
789 | xxxxxxxxxx      : yyyyyyyyyy         |
790 | xxxxxxxxxxxx    : yyyyyyyy           |
791 | xxxxxxxxxxxxxx  : yyyyyy             |
792 | xxxxxxxxxxxxxxx : yyyy               |
793 | x               : yy                 |
794 | xxxxxxxxxxxxxxx :                    |
795 | xxx                                  |
796 | xxxxxxxxxxxxxxx                      |
797 | xxxxx                                |
798 +-----------------+--------------------+
799 (2 rows)
800
801 \pset expanded on
802 \pset columns 20
803 \pset border 0
804 \pset format unaligned
805 execute q;
806 ab
807
808 c|xx
809 a
810 bc|yyyyyyyyyyyyyyyyyy
811
812 ab
813
814 c|xxxx
815 xxxxxx
816 xxxxxxxx
817 xxxxxxxxxx
818 xxxxxxxxxxxx
819 xxxxxxxxxxxxxx
820 xxxxxxxxxxxxxxxx
821 xxxxxxxxxxxxxxxxxx
822 xxxxxxxxxxxxxxxxxxxx
823 a
824 bc|yyyyyyyyyyyyyyyy
825 yyyyyyyyyyyyyy
826 yyyyyyyyyyyy
827 yyyyyyyyyy
828 yyyyyyyy
829 yyyyyy
830 yyyy
831 yy
832
833 \pset format aligned
834 execute q;
835 * Record 1             
836  ab xx
837 +  
838 +c 
839  a  yyyyyyyyyyyyyyyyyy
840 +bc
841 * Record 2             
842  ab xxxx
843 +   xxxxxx
844 +c  xxxxxxxx
845     xxxxxxxxxx
846     xxxxxxxxxxxx
847     xxxxxxxxxxxxxx
848     xxxxxxxxxxxxxxxx
849     xxxxxxxxxxxxxxxxxx
850     xxxxxxxxxxxxxxxxxxxx
851  a  yyyyyyyyyyyyyyyy
852 +bc yyyyyyyyyyyyyy
853     yyyyyyyyyyyy
854     yyyyyyyyyy
855     yyyyyyyy
856     yyyyyy
857     yyyy
858     yy
859     
860
861 \pset format wrapped
862 execute q;
863 * Record 1         
864  ab xx
865 +  
866 +c 
867  a  yyyyyyyyyyyyyyyy
868 +bc yy
869 * Record 2         
870  ab xxxx
871 +   xxxxxx
872 +c  xxxxxxxx
873     xxxxxxxxxx
874     xxxxxxxxxxxx
875     xxxxxxxxxxxxxx
876     xxxxxxxxxxxxxxxx
877     xxxxxxxxxxxxxxxx
878     xx
879     xxxxxxxxxxxxxxxx
880     xxxx
881  a  yyyyyyyyyyyyyyyy
882 +bc yyyyyyyyyyyyyy
883     yyyyyyyyyyyy
884     yyyyyyyyyy
885     yyyyyyyy
886     yyyyyy
887     yyyy
888     yy
889     
890
891 \pset border 1
892 \pset format unaligned
893 execute q;
894 ab
895
896 c|xx
897 a
898 bc|yyyyyyyyyyyyyyyyyy
899
900 ab
901
902 c|xxxx
903 xxxxxx
904 xxxxxxxx
905 xxxxxxxxxx
906 xxxxxxxxxxxx
907 xxxxxxxxxxxxxx
908 xxxxxxxxxxxxxxxx
909 xxxxxxxxxxxxxxxxxx
910 xxxxxxxxxxxxxxxxxxxx
911 a
912 bc|yyyyyyyyyyyyyyyy
913 yyyyyyyyyyyyyy
914 yyyyyyyyyyyy
915 yyyyyyyyyy
916 yyyyyyyy
917 yyyyyy
918 yyyy
919 yy
920
921 \pset format aligned
922 execute q;
923 -[ RECORD 1 ]-------------
924  ab | xx
925 +   ;
926 +c  ;
927  a  | yyyyyyyyyyyyyyyyyy
928 +bc ;
929 -[ RECORD 2 ]-------------
930  ab | xxxx
931 +   : xxxxxx
932 +c  : xxxxxxxx
933     : xxxxxxxxxx
934     : xxxxxxxxxxxx
935     : xxxxxxxxxxxxxx
936     : xxxxxxxxxxxxxxxx
937     : xxxxxxxxxxxxxxxxxx
938     : xxxxxxxxxxxxxxxxxxxx
939  a  | yyyyyyyyyyyyyyyy
940 +bc : yyyyyyyyyyyyyy
941     : yyyyyyyyyyyy
942     : yyyyyyyyyy
943     : yyyyyyyy
944     : yyyyyy
945     : yyyy
946     : yy
947     : 
948
949 \pset format wrapped
950 execute q;
951 -[ RECORD 1 ]-------
952  ab | xx
953 +   ;
954 +c  ;
955  a  | yyyyyyyyyyyyyy
956 +bc ; yyyy
957 -[ RECORD 2 ]-------
958  ab | xxxx
959 +   : xxxxxx
960 +c  : xxxxxxxx
961     : xxxxxxxxxx
962     : xxxxxxxxxxxx
963     : xxxxxxxxxxxxxx
964     : xxxxxxxxxxxxxx
965     ; xx
966     : xxxxxxxxxxxxxx
967     ; xxxx
968     : xxxxxxxxxxxxxx
969     ; xxxxxx
970  a  | yyyyyyyyyyyyyy
971 +bc ; yy
972     : yyyyyyyyyyyyyy
973     : yyyyyyyyyyyy
974     : yyyyyyyyyy
975     : yyyyyyyy
976     : yyyyyy
977     : yyyy
978     : yy
979     : 
980
981 \pset border 2
982 \pset format unaligned
983 execute q;
984 ab
985
986 c|xx
987 a
988 bc|yyyyyyyyyyyyyyyyyy
989
990 ab
991
992 c|xxxx
993 xxxxxx
994 xxxxxxxx
995 xxxxxxxxxx
996 xxxxxxxxxxxx
997 xxxxxxxxxxxxxx
998 xxxxxxxxxxxxxxxx
999 xxxxxxxxxxxxxxxxxx
1000 xxxxxxxxxxxxxxxxxxxx
1001 a
1002 bc|yyyyyyyyyyyyyyyy
1003 yyyyyyyyyyyyyy
1004 yyyyyyyyyyyy
1005 yyyyyyyyyy
1006 yyyyyyyy
1007 yyyyyy
1008 yyyy
1009 yy
1010
1011 \pset format aligned
1012 execute q;
1013 +-[ RECORD 1 ]--------------+
1014 | ab | xx                   |
1015 |+   ;                      |
1016 |+c  ;                      |
1017 | a  | yyyyyyyyyyyyyyyyyy   |
1018 |+bc ;                      |
1019 +-[ RECORD 2 ]--------------+
1020 | ab | xxxx                 |
1021 |+   : xxxxxx               |
1022 |+c  : xxxxxxxx             |
1023 |    : xxxxxxxxxx           |
1024 |    : xxxxxxxxxxxx         |
1025 |    : xxxxxxxxxxxxxx       |
1026 |    : xxxxxxxxxxxxxxxx     |
1027 |    : xxxxxxxxxxxxxxxxxx   |
1028 |    : xxxxxxxxxxxxxxxxxxxx |
1029 | a  | yyyyyyyyyyyyyyyy     |
1030 |+bc : yyyyyyyyyyyyyy       |
1031 |    : yyyyyyyyyyyy         |
1032 |    : yyyyyyyyyy           |
1033 |    : yyyyyyyy             |
1034 |    : yyyyyy               |
1035 |    : yyyy                 |
1036 |    : yy                   |
1037 |    :                      |
1038 +----+----------------------+
1039
1040 \pset format wrapped
1041 execute q;
1042 +-[ RECORD 1 ]-----+
1043 | ab | xx          |
1044 |+   ;             |
1045 |+c  ;             |
1046 | a  | yyyyyyyyyyy |
1047 |+bc ; yyyyyyy     |
1048 +-[ RECORD 2 ]-----+
1049 | ab | xxxx        |
1050 |+   : xxxxxx      |
1051 |+c  : xxxxxxxx    |
1052 |    : xxxxxxxxxx  |
1053 |    : xxxxxxxxxxx |
1054 |    ; x           |
1055 |    : xxxxxxxxxxx |
1056 |    ; xxx         |
1057 |    : xxxxxxxxxxx |
1058 |    ; xxxxx       |
1059 |    : xxxxxxxxxxx |
1060 |    ; xxxxxxx     |
1061 |    : xxxxxxxxxxx |
1062 |    ; xxxxxxxxx   |
1063 | a  | yyyyyyyyyyy |
1064 |+bc ; yyyyy       |
1065 |    : yyyyyyyyyyy |
1066 |    ; yyy         |
1067 |    : yyyyyyyyyyy |
1068 |    ; y           |
1069 |    : yyyyyyyyyy  |
1070 |    : yyyyyyyy    |
1071 |    : yyyyyy      |
1072 |    : yyyy        |
1073 |    : yy          |
1074 |    :             |
1075 +----+-------------+
1076
1077 deallocate q;
1078 -- test single-line header and data
1079 prepare q as select repeat('x',2*n) as "0123456789abcdef", repeat('y',20-2*n) as "0123456789" from generate_series(1,10) as n;
1080 \pset linestyle ascii
1081 \pset expanded off
1082 \pset columns 40
1083 \pset border 0
1084 \pset format unaligned
1085 execute q;
1086 0123456789abcdef|0123456789
1087 xx|yyyyyyyyyyyyyyyyyy
1088 xxxx|yyyyyyyyyyyyyyyy
1089 xxxxxx|yyyyyyyyyyyyyy
1090 xxxxxxxx|yyyyyyyyyyyy
1091 xxxxxxxxxx|yyyyyyyyyy
1092 xxxxxxxxxxxx|yyyyyyyy
1093 xxxxxxxxxxxxxx|yyyyyy
1094 xxxxxxxxxxxxxxxx|yyyy
1095 xxxxxxxxxxxxxxxxxx|yy
1096 xxxxxxxxxxxxxxxxxxxx|
1097 (10 rows)
1098 \pset format aligned
1099 execute q;
1100   0123456789abcdef       0123456789     
1101 -------------------- ------------------
1102 xx                   yyyyyyyyyyyyyyyyyy
1103 xxxx                 yyyyyyyyyyyyyyyy
1104 xxxxxx               yyyyyyyyyyyyyy
1105 xxxxxxxx             yyyyyyyyyyyy
1106 xxxxxxxxxx           yyyyyyyyyy
1107 xxxxxxxxxxxx         yyyyyyyy
1108 xxxxxxxxxxxxxx       yyyyyy
1109 xxxxxxxxxxxxxxxx     yyyy
1110 xxxxxxxxxxxxxxxxxx   yy
1111 xxxxxxxxxxxxxxxxxxxx 
1112 (10 rows)
1113
1114 \pset format wrapped
1115 execute q;
1116   0123456789abcdef       0123456789     
1117 -------------------- ------------------
1118 xx                   yyyyyyyyyyyyyyyyyy
1119 xxxx                 yyyyyyyyyyyyyyyy
1120 xxxxxx               yyyyyyyyyyyyyy
1121 xxxxxxxx             yyyyyyyyyyyy
1122 xxxxxxxxxx           yyyyyyyyyy
1123 xxxxxxxxxxxx         yyyyyyyy
1124 xxxxxxxxxxxxxx       yyyyyy
1125 xxxxxxxxxxxxxxxx     yyyy
1126 xxxxxxxxxxxxxxxxxx   yy
1127 xxxxxxxxxxxxxxxxxxxx 
1128 (10 rows)
1129
1130 \pset border 1
1131 \pset format unaligned
1132 execute q;
1133 0123456789abcdef|0123456789
1134 xx|yyyyyyyyyyyyyyyyyy
1135 xxxx|yyyyyyyyyyyyyyyy
1136 xxxxxx|yyyyyyyyyyyyyy
1137 xxxxxxxx|yyyyyyyyyyyy
1138 xxxxxxxxxx|yyyyyyyyyy
1139 xxxxxxxxxxxx|yyyyyyyy
1140 xxxxxxxxxxxxxx|yyyyyy
1141 xxxxxxxxxxxxxxxx|yyyy
1142 xxxxxxxxxxxxxxxxxx|yy
1143 xxxxxxxxxxxxxxxxxxxx|
1144 (10 rows)
1145 \pset format aligned
1146 execute q;
1147    0123456789abcdef   |     0123456789     
1148 ----------------------+--------------------
1149  xx                   | yyyyyyyyyyyyyyyyyy
1150  xxxx                 | yyyyyyyyyyyyyyyy
1151  xxxxxx               | yyyyyyyyyyyyyy
1152  xxxxxxxx             | yyyyyyyyyyyy
1153  xxxxxxxxxx           | yyyyyyyyyy
1154  xxxxxxxxxxxx         | yyyyyyyy
1155  xxxxxxxxxxxxxx       | yyyyyy
1156  xxxxxxxxxxxxxxxx     | yyyy
1157  xxxxxxxxxxxxxxxxxx   | yy
1158  xxxxxxxxxxxxxxxxxxxx | 
1159 (10 rows)
1160
1161 \pset format wrapped
1162 execute q;
1163   0123456789abcdef   |    0123456789    
1164 ---------------------+------------------
1165  xx                  | yyyyyyyyyyyyyyyy.
1166                      |.yy
1167  xxxx                | yyyyyyyyyyyyyyyy
1168  xxxxxx              | yyyyyyyyyyyyyy
1169  xxxxxxxx            | yyyyyyyyyyyy
1170  xxxxxxxxxx          | yyyyyyyyyy
1171  xxxxxxxxxxxx        | yyyyyyyy
1172  xxxxxxxxxxxxxx      | yyyyyy
1173  xxxxxxxxxxxxxxxx    | yyyy
1174  xxxxxxxxxxxxxxxxxx  | yy
1175  xxxxxxxxxxxxxxxxxxx.| 
1176 .x                   | 
1177 (10 rows)
1178
1179 \pset border 2
1180 \pset format unaligned
1181 execute q;
1182 0123456789abcdef|0123456789
1183 xx|yyyyyyyyyyyyyyyyyy
1184 xxxx|yyyyyyyyyyyyyyyy
1185 xxxxxx|yyyyyyyyyyyyyy
1186 xxxxxxxx|yyyyyyyyyyyy
1187 xxxxxxxxxx|yyyyyyyyyy
1188 xxxxxxxxxxxx|yyyyyyyy
1189 xxxxxxxxxxxxxx|yyyyyy
1190 xxxxxxxxxxxxxxxx|yyyy
1191 xxxxxxxxxxxxxxxxxx|yy
1192 xxxxxxxxxxxxxxxxxxxx|
1193 (10 rows)
1194 \pset format aligned
1195 execute q;
1196 +----------------------+--------------------+
1197 |   0123456789abcdef   |     0123456789     |
1198 +----------------------+--------------------+
1199 | xx                   | yyyyyyyyyyyyyyyyyy |
1200 | xxxx                 | yyyyyyyyyyyyyyyy   |
1201 | xxxxxx               | yyyyyyyyyyyyyy     |
1202 | xxxxxxxx             | yyyyyyyyyyyy       |
1203 | xxxxxxxxxx           | yyyyyyyyyy         |
1204 | xxxxxxxxxxxx         | yyyyyyyy           |
1205 | xxxxxxxxxxxxxx       | yyyyyy             |
1206 | xxxxxxxxxxxxxxxx     | yyyy               |
1207 | xxxxxxxxxxxxxxxxxx   | yy                 |
1208 | xxxxxxxxxxxxxxxxxxxx |                    |
1209 +----------------------+--------------------+
1210 (10 rows)
1211
1212 \pset format wrapped
1213 execute q;
1214 +--------------------+-----------------+
1215 |  0123456789abcdef  |   0123456789    |
1216 +--------------------+-----------------+
1217 | xx                 | yyyyyyyyyyyyyyy.|
1218 |                    |.yyy             |
1219 | xxxx               | yyyyyyyyyyyyyyy.|
1220 |                    |.y               |
1221 | xxxxxx             | yyyyyyyyyyyyyy  |
1222 | xxxxxxxx           | yyyyyyyyyyyy    |
1223 | xxxxxxxxxx         | yyyyyyyyyy      |
1224 | xxxxxxxxxxxx       | yyyyyyyy        |
1225 | xxxxxxxxxxxxxx     | yyyyyy          |
1226 | xxxxxxxxxxxxxxxx   | yyyy            |
1227 | xxxxxxxxxxxxxxxxxx | yy              |
1228 | xxxxxxxxxxxxxxxxxx.|                 |
1229 |.xx                 |                 |
1230 +--------------------+-----------------+
1231 (10 rows)
1232
1233 \pset expanded on
1234 \pset columns 30
1235 \pset border 0
1236 \pset format unaligned
1237 execute q;
1238 0123456789abcdef|xx
1239 0123456789|yyyyyyyyyyyyyyyyyy
1240
1241 0123456789abcdef|xxxx
1242 0123456789|yyyyyyyyyyyyyyyy
1243
1244 0123456789abcdef|xxxxxx
1245 0123456789|yyyyyyyyyyyyyy
1246
1247 0123456789abcdef|xxxxxxxx
1248 0123456789|yyyyyyyyyyyy
1249
1250 0123456789abcdef|xxxxxxxxxx
1251 0123456789|yyyyyyyyyy
1252
1253 0123456789abcdef|xxxxxxxxxxxx
1254 0123456789|yyyyyyyy
1255
1256 0123456789abcdef|xxxxxxxxxxxxxx
1257 0123456789|yyyyyy
1258
1259 0123456789abcdef|xxxxxxxxxxxxxxxx
1260 0123456789|yyyy
1261
1262 0123456789abcdef|xxxxxxxxxxxxxxxxxx
1263 0123456789|yy
1264
1265 0123456789abcdef|xxxxxxxxxxxxxxxxxxxx
1266 0123456789|
1267 \pset format aligned
1268 execute q;
1269 * Record 1                          
1270 0123456789abcdef xx
1271 0123456789       yyyyyyyyyyyyyyyyyy
1272 * Record 2                          
1273 0123456789abcdef xxxx
1274 0123456789       yyyyyyyyyyyyyyyy
1275 * Record 3                          
1276 0123456789abcdef xxxxxx
1277 0123456789       yyyyyyyyyyyyyy
1278 * Record 4                          
1279 0123456789abcdef xxxxxxxx
1280 0123456789       yyyyyyyyyyyy
1281 * Record 5                          
1282 0123456789abcdef xxxxxxxxxx
1283 0123456789       yyyyyyyyyy
1284 * Record 6                          
1285 0123456789abcdef xxxxxxxxxxxx
1286 0123456789       yyyyyyyy
1287 * Record 7                          
1288 0123456789abcdef xxxxxxxxxxxxxx
1289 0123456789       yyyyyy
1290 * Record 8                          
1291 0123456789abcdef xxxxxxxxxxxxxxxx
1292 0123456789       yyyy
1293 * Record 9                          
1294 0123456789abcdef xxxxxxxxxxxxxxxxxx
1295 0123456789       yy
1296 * Record 10                         
1297 0123456789abcdef xxxxxxxxxxxxxxxxxxxx
1298 0123456789       
1299
1300 \pset format wrapped
1301 execute q;
1302 * Record 1                  
1303 0123456789abcdef xx
1304 0123456789       yyyyyyyyyyyy.
1305                 .yyyyyy
1306 * Record 2                  
1307 0123456789abcdef xxxx
1308 0123456789       yyyyyyyyyyyy.
1309                 .yyyy
1310 * Record 3                  
1311 0123456789abcdef xxxxxx
1312 0123456789       yyyyyyyyyyyy.
1313                 .yy
1314 * Record 4                  
1315 0123456789abcdef xxxxxxxx
1316 0123456789       yyyyyyyyyyyy
1317 * Record 5                  
1318 0123456789abcdef xxxxxxxxxx
1319 0123456789       yyyyyyyyyy
1320 * Record 6                  
1321 0123456789abcdef xxxxxxxxxxxx
1322 0123456789       yyyyyyyy
1323 * Record 7                  
1324 0123456789abcdef xxxxxxxxxxxx.
1325                 .xx
1326 0123456789       yyyyyy
1327 * Record 8                  
1328 0123456789abcdef xxxxxxxxxxxx.
1329                 .xxxx
1330 0123456789       yyyy
1331 * Record 9                  
1332 0123456789abcdef xxxxxxxxxxxx.
1333                 .xxxxxx
1334 0123456789       yy
1335 * Record 10                 
1336 0123456789abcdef xxxxxxxxxxxx.
1337                 .xxxxxxxx
1338 0123456789       
1339
1340 \pset border 1
1341 \pset format unaligned
1342 execute q;
1343 0123456789abcdef|xx
1344 0123456789|yyyyyyyyyyyyyyyyyy
1345
1346 0123456789abcdef|xxxx
1347 0123456789|yyyyyyyyyyyyyyyy
1348
1349 0123456789abcdef|xxxxxx
1350 0123456789|yyyyyyyyyyyyyy
1351
1352 0123456789abcdef|xxxxxxxx
1353 0123456789|yyyyyyyyyyyy
1354
1355 0123456789abcdef|xxxxxxxxxx
1356 0123456789|yyyyyyyyyy
1357
1358 0123456789abcdef|xxxxxxxxxxxx
1359 0123456789|yyyyyyyy
1360
1361 0123456789abcdef|xxxxxxxxxxxxxx
1362 0123456789|yyyyyy
1363
1364 0123456789abcdef|xxxxxxxxxxxxxxxx
1365 0123456789|yyyy
1366
1367 0123456789abcdef|xxxxxxxxxxxxxxxxxx
1368 0123456789|yy
1369
1370 0123456789abcdef|xxxxxxxxxxxxxxxxxxxx
1371 0123456789|
1372 \pset format aligned
1373 execute q;
1374 -[ RECORD 1 ]----+---------------------
1375 0123456789abcdef | xx
1376 0123456789       | yyyyyyyyyyyyyyyyyy
1377 -[ RECORD 2 ]----+---------------------
1378 0123456789abcdef | xxxx
1379 0123456789       | yyyyyyyyyyyyyyyy
1380 -[ RECORD 3 ]----+---------------------
1381 0123456789abcdef | xxxxxx
1382 0123456789       | yyyyyyyyyyyyyy
1383 -[ RECORD 4 ]----+---------------------
1384 0123456789abcdef | xxxxxxxx
1385 0123456789       | yyyyyyyyyyyy
1386 -[ RECORD 5 ]----+---------------------
1387 0123456789abcdef | xxxxxxxxxx
1388 0123456789       | yyyyyyyyyy
1389 -[ RECORD 6 ]----+---------------------
1390 0123456789abcdef | xxxxxxxxxxxx
1391 0123456789       | yyyyyyyy
1392 -[ RECORD 7 ]----+---------------------
1393 0123456789abcdef | xxxxxxxxxxxxxx
1394 0123456789       | yyyyyy
1395 -[ RECORD 8 ]----+---------------------
1396 0123456789abcdef | xxxxxxxxxxxxxxxx
1397 0123456789       | yyyy
1398 -[ RECORD 9 ]----+---------------------
1399 0123456789abcdef | xxxxxxxxxxxxxxxxxx
1400 0123456789       | yy
1401 -[ RECORD 10 ]---+---------------------
1402 0123456789abcdef | xxxxxxxxxxxxxxxxxxxx
1403 0123456789       | 
1404
1405 \pset format wrapped
1406 execute q;
1407 -[ RECORD 1 ]----+-----------
1408 0123456789abcdef | xx
1409 0123456789       | yyyyyyyyyy.
1410                  |.yyyyyyyy
1411 -[ RECORD 2 ]----+-----------
1412 0123456789abcdef | xxxx
1413 0123456789       | yyyyyyyyyy.
1414                  |.yyyyyy
1415 -[ RECORD 3 ]----+-----------
1416 0123456789abcdef | xxxxxx
1417 0123456789       | yyyyyyyyyy.
1418                  |.yyyy
1419 -[ RECORD 4 ]----+-----------
1420 0123456789abcdef | xxxxxxxx
1421 0123456789       | yyyyyyyyyy.
1422                  |.yy
1423 -[ RECORD 5 ]----+-----------
1424 0123456789abcdef | xxxxxxxxxx
1425 0123456789       | yyyyyyyyyy
1426 -[ RECORD 6 ]----+-----------
1427 0123456789abcdef | xxxxxxxxxx.
1428                  |.xx
1429 0123456789       | yyyyyyyy
1430 -[ RECORD 7 ]----+-----------
1431 0123456789abcdef | xxxxxxxxxx.
1432                  |.xxxx
1433 0123456789       | yyyyyy
1434 -[ RECORD 8 ]----+-----------
1435 0123456789abcdef | xxxxxxxxxx.
1436                  |.xxxxxx
1437 0123456789       | yyyy
1438 -[ RECORD 9 ]----+-----------
1439 0123456789abcdef | xxxxxxxxxx.
1440                  |.xxxxxxxx
1441 0123456789       | yy
1442 -[ RECORD 10 ]---+-----------
1443 0123456789abcdef | xxxxxxxxxx.
1444                  |.xxxxxxxxxx
1445 0123456789       | 
1446
1447 \pset border 2
1448 \pset format unaligned
1449 execute q;
1450 0123456789abcdef|xx
1451 0123456789|yyyyyyyyyyyyyyyyyy
1452
1453 0123456789abcdef|xxxx
1454 0123456789|yyyyyyyyyyyyyyyy
1455
1456 0123456789abcdef|xxxxxx
1457 0123456789|yyyyyyyyyyyyyy
1458
1459 0123456789abcdef|xxxxxxxx
1460 0123456789|yyyyyyyyyyyy
1461
1462 0123456789abcdef|xxxxxxxxxx
1463 0123456789|yyyyyyyyyy
1464
1465 0123456789abcdef|xxxxxxxxxxxx
1466 0123456789|yyyyyyyy
1467
1468 0123456789abcdef|xxxxxxxxxxxxxx
1469 0123456789|yyyyyy
1470
1471 0123456789abcdef|xxxxxxxxxxxxxxxx
1472 0123456789|yyyy
1473
1474 0123456789abcdef|xxxxxxxxxxxxxxxxxx
1475 0123456789|yy
1476
1477 0123456789abcdef|xxxxxxxxxxxxxxxxxxxx
1478 0123456789|
1479 \pset format aligned
1480 execute q;
1481 +-[ RECORD 1 ]-----+----------------------+
1482 | 0123456789abcdef | xx                   |
1483 | 0123456789       | yyyyyyyyyyyyyyyyyy   |
1484 +-[ RECORD 2 ]-----+----------------------+
1485 | 0123456789abcdef | xxxx                 |
1486 | 0123456789       | yyyyyyyyyyyyyyyy     |
1487 +-[ RECORD 3 ]-----+----------------------+
1488 | 0123456789abcdef | xxxxxx               |
1489 | 0123456789       | yyyyyyyyyyyyyy       |
1490 +-[ RECORD 4 ]-----+----------------------+
1491 | 0123456789abcdef | xxxxxxxx             |
1492 | 0123456789       | yyyyyyyyyyyy         |
1493 +-[ RECORD 5 ]-----+----------------------+
1494 | 0123456789abcdef | xxxxxxxxxx           |
1495 | 0123456789       | yyyyyyyyyy           |
1496 +-[ RECORD 6 ]-----+----------------------+
1497 | 0123456789abcdef | xxxxxxxxxxxx         |
1498 | 0123456789       | yyyyyyyy             |
1499 +-[ RECORD 7 ]-----+----------------------+
1500 | 0123456789abcdef | xxxxxxxxxxxxxx       |
1501 | 0123456789       | yyyyyy               |
1502 +-[ RECORD 8 ]-----+----------------------+
1503 | 0123456789abcdef | xxxxxxxxxxxxxxxx     |
1504 | 0123456789       | yyyy                 |
1505 +-[ RECORD 9 ]-----+----------------------+
1506 | 0123456789abcdef | xxxxxxxxxxxxxxxxxx   |
1507 | 0123456789       | yy                   |
1508 +-[ RECORD 10 ]----+----------------------+
1509 | 0123456789abcdef | xxxxxxxxxxxxxxxxxxxx |
1510 | 0123456789       |                      |
1511 +------------------+----------------------+
1512
1513 \pset format wrapped
1514 execute q;
1515 +-[ RECORD 1 ]-----+---------+
1516 | 0123456789abcdef | xx      |
1517 | 0123456789       | yyyyyyy.|
1518 |                  |.yyyyyyy.|
1519 |                  |.yyyy    |
1520 +-[ RECORD 2 ]-----+---------+
1521 | 0123456789abcdef | xxxx    |
1522 | 0123456789       | yyyyyyy.|
1523 |                  |.yyyyyyy.|
1524 |                  |.yy      |
1525 +-[ RECORD 3 ]-----+---------+
1526 | 0123456789abcdef | xxxxxx  |
1527 | 0123456789       | yyyyyyy.|
1528 |                  |.yyyyyyy |
1529 +-[ RECORD 4 ]-----+---------+
1530 | 0123456789abcdef | xxxxxxx.|
1531 |                  |.x       |
1532 | 0123456789       | yyyyyyy.|
1533 |                  |.yyyyy   |
1534 +-[ RECORD 5 ]-----+---------+
1535 | 0123456789abcdef | xxxxxxx.|
1536 |                  |.xxx     |
1537 | 0123456789       | yyyyyyy.|
1538 |                  |.yyy     |
1539 +-[ RECORD 6 ]-----+---------+
1540 | 0123456789abcdef | xxxxxxx.|
1541 |                  |.xxxxx   |
1542 | 0123456789       | yyyyyyy.|
1543 |                  |.y       |
1544 +-[ RECORD 7 ]-----+---------+
1545 | 0123456789abcdef | xxxxxxx.|
1546 |                  |.xxxxxxx |
1547 | 0123456789       | yyyyyy  |
1548 +-[ RECORD 8 ]-----+---------+
1549 | 0123456789abcdef | xxxxxxx.|
1550 |                  |.xxxxxxx.|
1551 |                  |.xx      |
1552 | 0123456789       | yyyy    |
1553 +-[ RECORD 9 ]-----+---------+
1554 | 0123456789abcdef | xxxxxxx.|
1555 |                  |.xxxxxxx.|
1556 |                  |.xxxx    |
1557 | 0123456789       | yy      |
1558 +-[ RECORD 10 ]----+---------+
1559 | 0123456789abcdef | xxxxxxx.|
1560 |                  |.xxxxxxx.|
1561 |                  |.xxxxxx  |
1562 | 0123456789       |         |
1563 +------------------+---------+
1564
1565 \pset expanded on
1566 \pset columns 20
1567 \pset border 0
1568 \pset format unaligned
1569 execute q;
1570 0123456789abcdef|xx
1571 0123456789|yyyyyyyyyyyyyyyyyy
1572
1573 0123456789abcdef|xxxx
1574 0123456789|yyyyyyyyyyyyyyyy
1575
1576 0123456789abcdef|xxxxxx
1577 0123456789|yyyyyyyyyyyyyy
1578
1579 0123456789abcdef|xxxxxxxx
1580 0123456789|yyyyyyyyyyyy
1581
1582 0123456789abcdef|xxxxxxxxxx
1583 0123456789|yyyyyyyyyy
1584
1585 0123456789abcdef|xxxxxxxxxxxx
1586 0123456789|yyyyyyyy
1587
1588 0123456789abcdef|xxxxxxxxxxxxxx
1589 0123456789|yyyyyy
1590
1591 0123456789abcdef|xxxxxxxxxxxxxxxx
1592 0123456789|yyyy
1593
1594 0123456789abcdef|xxxxxxxxxxxxxxxxxx
1595 0123456789|yy
1596
1597 0123456789abcdef|xxxxxxxxxxxxxxxxxxxx
1598 0123456789|
1599 \pset format aligned
1600 execute q;
1601 * Record 1                          
1602 0123456789abcdef xx
1603 0123456789       yyyyyyyyyyyyyyyyyy
1604 * Record 2                          
1605 0123456789abcdef xxxx
1606 0123456789       yyyyyyyyyyyyyyyy
1607 * Record 3                          
1608 0123456789abcdef xxxxxx
1609 0123456789       yyyyyyyyyyyyyy
1610 * Record 4                          
1611 0123456789abcdef xxxxxxxx
1612 0123456789       yyyyyyyyyyyy
1613 * Record 5                          
1614 0123456789abcdef xxxxxxxxxx
1615 0123456789       yyyyyyyyyy
1616 * Record 6                          
1617 0123456789abcdef xxxxxxxxxxxx
1618 0123456789       yyyyyyyy
1619 * Record 7                          
1620 0123456789abcdef xxxxxxxxxxxxxx
1621 0123456789       yyyyyy
1622 * Record 8                          
1623 0123456789abcdef xxxxxxxxxxxxxxxx
1624 0123456789       yyyy
1625 * Record 9                          
1626 0123456789abcdef xxxxxxxxxxxxxxxxxx
1627 0123456789       yy
1628 * Record 10                         
1629 0123456789abcdef xxxxxxxxxxxxxxxxxxxx
1630 0123456789       
1631
1632 \pset format wrapped
1633 execute q;
1634 * Record 1         
1635 0123456789abcdef xx
1636 0123456789       yyy.
1637                 .yyy.
1638                 .yyy.
1639                 .yyy.
1640                 .yyy.
1641                 .yyy
1642 * Record 2         
1643 0123456789abcdef xxx.
1644                 .x
1645 0123456789       yyy.
1646                 .yyy.
1647                 .yyy.
1648                 .yyy.
1649                 .yyy.
1650                 .y
1651 * Record 3         
1652 0123456789abcdef xxx.
1653                 .xxx
1654 0123456789       yyy.
1655                 .yyy.
1656                 .yyy.
1657                 .yyy.
1658                 .yy
1659 * Record 4         
1660 0123456789abcdef xxx.
1661                 .xxx.
1662                 .xx
1663 0123456789       yyy.
1664                 .yyy.
1665                 .yyy.
1666                 .yyy
1667 * Record 5         
1668 0123456789abcdef xxx.
1669                 .xxx.
1670                 .xxx.
1671                 .x
1672 0123456789       yyy.
1673                 .yyy.
1674                 .yyy.
1675                 .y
1676 * Record 6         
1677 0123456789abcdef xxx.
1678                 .xxx.
1679                 .xxx.
1680                 .xxx
1681 0123456789       yyy.
1682                 .yyy.
1683                 .yy
1684 * Record 7         
1685 0123456789abcdef xxx.
1686                 .xxx.
1687                 .xxx.
1688                 .xxx.
1689                 .xx
1690 0123456789       yyy.
1691                 .yyy
1692 * Record 8         
1693 0123456789abcdef xxx.
1694                 .xxx.
1695                 .xxx.
1696                 .xxx.
1697                 .xxx.
1698                 .x
1699 0123456789       yyy.
1700                 .y
1701 * Record 9         
1702 0123456789abcdef xxx.
1703                 .xxx.
1704                 .xxx.
1705                 .xxx.
1706                 .xxx.
1707                 .xxx
1708 0123456789       yy
1709 * Record 10        
1710 0123456789abcdef xxx.
1711                 .xxx.
1712                 .xxx.
1713                 .xxx.
1714                 .xxx.
1715                 .xxx.
1716                 .xx
1717 0123456789       
1718
1719 \pset border 1
1720 \pset format unaligned
1721 execute q;
1722 0123456789abcdef|xx
1723 0123456789|yyyyyyyyyyyyyyyyyy
1724
1725 0123456789abcdef|xxxx
1726 0123456789|yyyyyyyyyyyyyyyy
1727
1728 0123456789abcdef|xxxxxx
1729 0123456789|yyyyyyyyyyyyyy
1730
1731 0123456789abcdef|xxxxxxxx
1732 0123456789|yyyyyyyyyyyy
1733
1734 0123456789abcdef|xxxxxxxxxx
1735 0123456789|yyyyyyyyyy
1736
1737 0123456789abcdef|xxxxxxxxxxxx
1738 0123456789|yyyyyyyy
1739
1740 0123456789abcdef|xxxxxxxxxxxxxx
1741 0123456789|yyyyyy
1742
1743 0123456789abcdef|xxxxxxxxxxxxxxxx
1744 0123456789|yyyy
1745
1746 0123456789abcdef|xxxxxxxxxxxxxxxxxx
1747 0123456789|yy
1748
1749 0123456789abcdef|xxxxxxxxxxxxxxxxxxxx
1750 0123456789|
1751 \pset format aligned
1752 execute q;
1753 -[ RECORD 1 ]----+---------------------
1754 0123456789abcdef | xx
1755 0123456789       | yyyyyyyyyyyyyyyyyy
1756 -[ RECORD 2 ]----+---------------------
1757 0123456789abcdef | xxxx
1758 0123456789       | yyyyyyyyyyyyyyyy
1759 -[ RECORD 3 ]----+---------------------
1760 0123456789abcdef | xxxxxx
1761 0123456789       | yyyyyyyyyyyyyy
1762 -[ RECORD 4 ]----+---------------------
1763 0123456789abcdef | xxxxxxxx
1764 0123456789       | yyyyyyyyyyyy
1765 -[ RECORD 5 ]----+---------------------
1766 0123456789abcdef | xxxxxxxxxx
1767 0123456789       | yyyyyyyyyy
1768 -[ RECORD 6 ]----+---------------------
1769 0123456789abcdef | xxxxxxxxxxxx
1770 0123456789       | yyyyyyyy
1771 -[ RECORD 7 ]----+---------------------
1772 0123456789abcdef | xxxxxxxxxxxxxx
1773 0123456789       | yyyyyy
1774 -[ RECORD 8 ]----+---------------------
1775 0123456789abcdef | xxxxxxxxxxxxxxxx
1776 0123456789       | yyyy
1777 -[ RECORD 9 ]----+---------------------
1778 0123456789abcdef | xxxxxxxxxxxxxxxxxx
1779 0123456789       | yy
1780 -[ RECORD 10 ]---+---------------------
1781 0123456789abcdef | xxxxxxxxxxxxxxxxxxxx
1782 0123456789       | 
1783
1784 \pset format wrapped
1785 execute q;
1786 -[ RECORD 1 ]----+----
1787 0123456789abcdef | xx
1788 0123456789       | yyy.
1789                  |.yyy.
1790                  |.yyy.
1791                  |.yyy.
1792                  |.yyy.
1793                  |.yyy
1794 -[ RECORD 2 ]----+----
1795 0123456789abcdef | xxx.
1796                  |.x
1797 0123456789       | yyy.
1798                  |.yyy.
1799                  |.yyy.
1800                  |.yyy.
1801                  |.yyy.
1802                  |.y
1803 -[ RECORD 3 ]----+----
1804 0123456789abcdef | xxx.
1805                  |.xxx
1806 0123456789       | yyy.
1807                  |.yyy.
1808                  |.yyy.
1809                  |.yyy.
1810                  |.yy
1811 -[ RECORD 4 ]----+----
1812 0123456789abcdef | xxx.
1813                  |.xxx.
1814                  |.xx
1815 0123456789       | yyy.
1816                  |.yyy.
1817                  |.yyy.
1818                  |.yyy
1819 -[ RECORD 5 ]----+----
1820 0123456789abcdef | xxx.
1821                  |.xxx.
1822                  |.xxx.
1823                  |.x
1824 0123456789       | yyy.
1825                  |.yyy.
1826                  |.yyy.
1827                  |.y
1828 -[ RECORD 6 ]----+----
1829 0123456789abcdef | xxx.
1830                  |.xxx.
1831                  |.xxx.
1832                  |.xxx
1833 0123456789       | yyy.
1834                  |.yyy.
1835                  |.yy
1836 -[ RECORD 7 ]----+----
1837 0123456789abcdef | xxx.
1838                  |.xxx.
1839                  |.xxx.
1840                  |.xxx.
1841                  |.xx
1842 0123456789       | yyy.
1843                  |.yyy
1844 -[ RECORD 8 ]----+----
1845 0123456789abcdef | xxx.
1846                  |.xxx.
1847                  |.xxx.
1848                  |.xxx.
1849                  |.xxx.
1850                  |.x
1851 0123456789       | yyy.
1852                  |.y
1853 -[ RECORD 9 ]----+----
1854 0123456789abcdef | xxx.
1855                  |.xxx.
1856                  |.xxx.
1857                  |.xxx.
1858                  |.xxx.
1859                  |.xxx
1860 0123456789       | yy
1861 -[ RECORD 10 ]---+----
1862 0123456789abcdef | xxx.
1863                  |.xxx.
1864                  |.xxx.
1865                  |.xxx.
1866                  |.xxx.
1867                  |.xxx.
1868                  |.xx
1869 0123456789       | 
1870
1871 \pset border 2
1872 \pset format unaligned
1873 execute q;
1874 0123456789abcdef|xx
1875 0123456789|yyyyyyyyyyyyyyyyyy
1876
1877 0123456789abcdef|xxxx
1878 0123456789|yyyyyyyyyyyyyyyy
1879
1880 0123456789abcdef|xxxxxx
1881 0123456789|yyyyyyyyyyyyyy
1882
1883 0123456789abcdef|xxxxxxxx
1884 0123456789|yyyyyyyyyyyy
1885
1886 0123456789abcdef|xxxxxxxxxx
1887 0123456789|yyyyyyyyyy
1888
1889 0123456789abcdef|xxxxxxxxxxxx
1890 0123456789|yyyyyyyy
1891
1892 0123456789abcdef|xxxxxxxxxxxxxx
1893 0123456789|yyyyyy
1894
1895 0123456789abcdef|xxxxxxxxxxxxxxxx
1896 0123456789|yyyy
1897
1898 0123456789abcdef|xxxxxxxxxxxxxxxxxx
1899 0123456789|yy
1900
1901 0123456789abcdef|xxxxxxxxxxxxxxxxxxxx
1902 0123456789|
1903 \pset format aligned
1904 execute q;
1905 +-[ RECORD 1 ]-----+----------------------+
1906 | 0123456789abcdef | xx                   |
1907 | 0123456789       | yyyyyyyyyyyyyyyyyy   |
1908 +-[ RECORD 2 ]-----+----------------------+
1909 | 0123456789abcdef | xxxx                 |
1910 | 0123456789       | yyyyyyyyyyyyyyyy     |
1911 +-[ RECORD 3 ]-----+----------------------+
1912 | 0123456789abcdef | xxxxxx               |
1913 | 0123456789       | yyyyyyyyyyyyyy       |
1914 +-[ RECORD 4 ]-----+----------------------+
1915 | 0123456789abcdef | xxxxxxxx             |
1916 | 0123456789       | yyyyyyyyyyyy         |
1917 +-[ RECORD 5 ]-----+----------------------+
1918 | 0123456789abcdef | xxxxxxxxxx           |
1919 | 0123456789       | yyyyyyyyyy           |
1920 +-[ RECORD 6 ]-----+----------------------+
1921 | 0123456789abcdef | xxxxxxxxxxxx         |
1922 | 0123456789       | yyyyyyyy             |
1923 +-[ RECORD 7 ]-----+----------------------+
1924 | 0123456789abcdef | xxxxxxxxxxxxxx       |
1925 | 0123456789       | yyyyyy               |
1926 +-[ RECORD 8 ]-----+----------------------+
1927 | 0123456789abcdef | xxxxxxxxxxxxxxxx     |
1928 | 0123456789       | yyyy                 |
1929 +-[ RECORD 9 ]-----+----------------------+
1930 | 0123456789abcdef | xxxxxxxxxxxxxxxxxx   |
1931 | 0123456789       | yy                   |
1932 +-[ RECORD 10 ]----+----------------------+
1933 | 0123456789abcdef | xxxxxxxxxxxxxxxxxxxx |
1934 | 0123456789       |                      |
1935 +------------------+----------------------+
1936
1937 \pset format wrapped
1938 execute q;
1939 +-[ RECORD 1 ]-----+-----+
1940 | 0123456789abcdef | xx  |
1941 | 0123456789       | yyy.|
1942 |                  |.yyy.|
1943 |                  |.yyy.|
1944 |                  |.yyy.|
1945 |                  |.yyy.|
1946 |                  |.yyy |
1947 +-[ RECORD 2 ]-----+-----+
1948 | 0123456789abcdef | xxx.|
1949 |                  |.x   |
1950 | 0123456789       | yyy.|
1951 |                  |.yyy.|
1952 |                  |.yyy.|
1953 |                  |.yyy.|
1954 |                  |.yyy.|
1955 |                  |.y   |
1956 +-[ RECORD 3 ]-----+-----+
1957 | 0123456789abcdef | xxx.|
1958 |                  |.xxx |
1959 | 0123456789       | yyy.|
1960 |                  |.yyy.|
1961 |                  |.yyy.|
1962 |                  |.yyy.|
1963 |                  |.yy  |
1964 +-[ RECORD 4 ]-----+-----+
1965 | 0123456789abcdef | xxx.|
1966 |                  |.xxx.|
1967 |                  |.xx  |
1968 | 0123456789       | yyy.|
1969 |                  |.yyy.|
1970 |                  |.yyy.|
1971 |                  |.yyy |
1972 +-[ RECORD 5 ]-----+-----+
1973 | 0123456789abcdef | xxx.|
1974 |                  |.xxx.|
1975 |                  |.xxx.|
1976 |                  |.x   |
1977 | 0123456789       | yyy.|
1978 |                  |.yyy.|
1979 |                  |.yyy.|
1980 |                  |.y   |
1981 +-[ RECORD 6 ]-----+-----+
1982 | 0123456789abcdef | xxx.|
1983 |                  |.xxx.|
1984 |                  |.xxx.|
1985 |                  |.xxx |
1986 | 0123456789       | yyy.|
1987 |                  |.yyy.|
1988 |                  |.yy  |
1989 +-[ RECORD 7 ]-----+-----+
1990 | 0123456789abcdef | xxx.|
1991 |                  |.xxx.|
1992 |                  |.xxx.|
1993 |                  |.xxx.|
1994 |                  |.xx  |
1995 | 0123456789       | yyy.|
1996 |                  |.yyy |
1997 +-[ RECORD 8 ]-----+-----+
1998 | 0123456789abcdef | xxx.|
1999 |                  |.xxx.|
2000 |                  |.xxx.|
2001 |                  |.xxx.|
2002 |                  |.xxx.|
2003 |                  |.x   |
2004 | 0123456789       | yyy.|
2005 |                  |.y   |
2006 +-[ RECORD 9 ]-----+-----+
2007 | 0123456789abcdef | xxx.|
2008 |                  |.xxx.|
2009 |                  |.xxx.|
2010 |                  |.xxx.|
2011 |                  |.xxx.|
2012 |                  |.xxx |
2013 | 0123456789       | yy  |
2014 +-[ RECORD 10 ]----+-----+
2015 | 0123456789abcdef | xxx.|
2016 |                  |.xxx.|
2017 |                  |.xxx.|
2018 |                  |.xxx.|
2019 |                  |.xxx.|
2020 |                  |.xxx.|
2021 |                  |.xx  |
2022 | 0123456789       |     |
2023 +------------------+-----+
2024
2025 \pset linestyle old-ascii
2026 \pset expanded off
2027 \pset columns 40
2028 \pset border 0
2029 \pset format unaligned
2030 execute q;
2031 0123456789abcdef|0123456789
2032 xx|yyyyyyyyyyyyyyyyyy
2033 xxxx|yyyyyyyyyyyyyyyy
2034 xxxxxx|yyyyyyyyyyyyyy
2035 xxxxxxxx|yyyyyyyyyyyy
2036 xxxxxxxxxx|yyyyyyyyyy
2037 xxxxxxxxxxxx|yyyyyyyy
2038 xxxxxxxxxxxxxx|yyyyyy
2039 xxxxxxxxxxxxxxxx|yyyy
2040 xxxxxxxxxxxxxxxxxx|yy
2041 xxxxxxxxxxxxxxxxxxxx|
2042 (10 rows)
2043 \pset format aligned
2044 execute q;
2045   0123456789abcdef       0123456789    
2046 -------------------- ------------------
2047 xx                   yyyyyyyyyyyyyyyyyy
2048 xxxx                 yyyyyyyyyyyyyyyy
2049 xxxxxx               yyyyyyyyyyyyyy
2050 xxxxxxxx             yyyyyyyyyyyy
2051 xxxxxxxxxx           yyyyyyyyyy
2052 xxxxxxxxxxxx         yyyyyyyy
2053 xxxxxxxxxxxxxx       yyyyyy
2054 xxxxxxxxxxxxxxxx     yyyy
2055 xxxxxxxxxxxxxxxxxx   yy
2056 xxxxxxxxxxxxxxxxxxxx 
2057 (10 rows)
2058
2059 \pset format wrapped
2060 execute q;
2061   0123456789abcdef       0123456789    
2062 -------------------- ------------------
2063 xx                   yyyyyyyyyyyyyyyyyy
2064 xxxx                 yyyyyyyyyyyyyyyy
2065 xxxxxx               yyyyyyyyyyyyyy
2066 xxxxxxxx             yyyyyyyyyyyy
2067 xxxxxxxxxx           yyyyyyyyyy
2068 xxxxxxxxxxxx         yyyyyyyy
2069 xxxxxxxxxxxxxx       yyyyyy
2070 xxxxxxxxxxxxxxxx     yyyy
2071 xxxxxxxxxxxxxxxxxx   yy
2072 xxxxxxxxxxxxxxxxxxxx 
2073 (10 rows)
2074
2075 \pset border 1
2076 \pset format unaligned
2077 execute q;
2078 0123456789abcdef|0123456789
2079 xx|yyyyyyyyyyyyyyyyyy
2080 xxxx|yyyyyyyyyyyyyyyy
2081 xxxxxx|yyyyyyyyyyyyyy
2082 xxxxxxxx|yyyyyyyyyyyy
2083 xxxxxxxxxx|yyyyyyyyyy
2084 xxxxxxxxxxxx|yyyyyyyy
2085 xxxxxxxxxxxxxx|yyyyyy
2086 xxxxxxxxxxxxxxxx|yyyy
2087 xxxxxxxxxxxxxxxxxx|yy
2088 xxxxxxxxxxxxxxxxxxxx|
2089 (10 rows)
2090 \pset format aligned
2091 execute q;
2092    0123456789abcdef   |     0123456789     
2093 ----------------------+--------------------
2094  xx                   | yyyyyyyyyyyyyyyyyy
2095  xxxx                 | yyyyyyyyyyyyyyyy
2096  xxxxxx               | yyyyyyyyyyyyyy
2097  xxxxxxxx             | yyyyyyyyyyyy
2098  xxxxxxxxxx           | yyyyyyyyyy
2099  xxxxxxxxxxxx         | yyyyyyyy
2100  xxxxxxxxxxxxxx       | yyyyyy
2101  xxxxxxxxxxxxxxxx     | yyyy
2102  xxxxxxxxxxxxxxxxxx   | yy
2103  xxxxxxxxxxxxxxxxxxxx | 
2104 (10 rows)
2105
2106 \pset format wrapped
2107 execute q;
2108   0123456789abcdef   |    0123456789    
2109 ---------------------+------------------
2110  xx                  | yyyyyyyyyyyyyyyy 
2111                      ; yy
2112  xxxx                | yyyyyyyyyyyyyyyy
2113  xxxxxx              | yyyyyyyyyyyyyy
2114  xxxxxxxx            | yyyyyyyyyyyy
2115  xxxxxxxxxx          | yyyyyyyyyy
2116  xxxxxxxxxxxx        | yyyyyyyy
2117  xxxxxxxxxxxxxx      | yyyyyy
2118  xxxxxxxxxxxxxxxx    | yyyy
2119  xxxxxxxxxxxxxxxxxx  | yy
2120  xxxxxxxxxxxxxxxxxxx | 
2121  x                     
2122 (10 rows)
2123
2124 \pset border 2
2125 \pset format unaligned
2126 execute q;
2127 0123456789abcdef|0123456789
2128 xx|yyyyyyyyyyyyyyyyyy
2129 xxxx|yyyyyyyyyyyyyyyy
2130 xxxxxx|yyyyyyyyyyyyyy
2131 xxxxxxxx|yyyyyyyyyyyy
2132 xxxxxxxxxx|yyyyyyyyyy
2133 xxxxxxxxxxxx|yyyyyyyy
2134 xxxxxxxxxxxxxx|yyyyyy
2135 xxxxxxxxxxxxxxxx|yyyy
2136 xxxxxxxxxxxxxxxxxx|yy
2137 xxxxxxxxxxxxxxxxxxxx|
2138 (10 rows)
2139 \pset format aligned
2140 execute q;
2141 +----------------------+--------------------+
2142 |   0123456789abcdef   |     0123456789     |
2143 +----------------------+--------------------+
2144 | xx                   | yyyyyyyyyyyyyyyyyy |
2145 | xxxx                 | yyyyyyyyyyyyyyyy   |
2146 | xxxxxx               | yyyyyyyyyyyyyy     |
2147 | xxxxxxxx             | yyyyyyyyyyyy       |
2148 | xxxxxxxxxx           | yyyyyyyyyy         |
2149 | xxxxxxxxxxxx         | yyyyyyyy           |
2150 | xxxxxxxxxxxxxx       | yyyyyy             |
2151 | xxxxxxxxxxxxxxxx     | yyyy               |
2152 | xxxxxxxxxxxxxxxxxx   | yy                 |
2153 | xxxxxxxxxxxxxxxxxxxx |                    |
2154 +----------------------+--------------------+
2155 (10 rows)
2156
2157 \pset format wrapped
2158 execute q;
2159 +--------------------+-----------------+
2160 |  0123456789abcdef  |   0123456789    |
2161 +--------------------+-----------------+
2162 | xx                 | yyyyyyyyyyyyyyy |
2163 |                    ; yyy             |
2164 | xxxx               | yyyyyyyyyyyyyyy |
2165 |                    ; y               |
2166 | xxxxxx             | yyyyyyyyyyyyyy  |
2167 | xxxxxxxx           | yyyyyyyyyyyy    |
2168 | xxxxxxxxxx         | yyyyyyyyyy      |
2169 | xxxxxxxxxxxx       | yyyyyyyy        |
2170 | xxxxxxxxxxxxxx     | yyyyyy          |
2171 | xxxxxxxxxxxxxxxx   | yyyy            |
2172 | xxxxxxxxxxxxxxxxxx | yy              |
2173 | xxxxxxxxxxxxxxxxxx |                 |
2174 | xx                                   |
2175 +--------------------+-----------------+
2176 (10 rows)
2177
2178 \pset expanded on
2179 \pset border 0
2180 \pset format unaligned
2181 execute q;
2182 0123456789abcdef|xx
2183 0123456789|yyyyyyyyyyyyyyyyyy
2184
2185 0123456789abcdef|xxxx
2186 0123456789|yyyyyyyyyyyyyyyy
2187
2188 0123456789abcdef|xxxxxx
2189 0123456789|yyyyyyyyyyyyyy
2190
2191 0123456789abcdef|xxxxxxxx
2192 0123456789|yyyyyyyyyyyy
2193
2194 0123456789abcdef|xxxxxxxxxx
2195 0123456789|yyyyyyyyyy
2196
2197 0123456789abcdef|xxxxxxxxxxxx
2198 0123456789|yyyyyyyy
2199
2200 0123456789abcdef|xxxxxxxxxxxxxx
2201 0123456789|yyyyyy
2202
2203 0123456789abcdef|xxxxxxxxxxxxxxxx
2204 0123456789|yyyy
2205
2206 0123456789abcdef|xxxxxxxxxxxxxxxxxx
2207 0123456789|yy
2208
2209 0123456789abcdef|xxxxxxxxxxxxxxxxxxxx
2210 0123456789|
2211 \pset format aligned
2212 execute q;
2213 * Record 1                          
2214 0123456789abcdef xx
2215 0123456789       yyyyyyyyyyyyyyyyyy
2216 * Record 2                          
2217 0123456789abcdef xxxx
2218 0123456789       yyyyyyyyyyyyyyyy
2219 * Record 3                          
2220 0123456789abcdef xxxxxx
2221 0123456789       yyyyyyyyyyyyyy
2222 * Record 4                          
2223 0123456789abcdef xxxxxxxx
2224 0123456789       yyyyyyyyyyyy
2225 * Record 5                          
2226 0123456789abcdef xxxxxxxxxx
2227 0123456789       yyyyyyyyyy
2228 * Record 6                          
2229 0123456789abcdef xxxxxxxxxxxx
2230 0123456789       yyyyyyyy
2231 * Record 7                          
2232 0123456789abcdef xxxxxxxxxxxxxx
2233 0123456789       yyyyyy
2234 * Record 8                          
2235 0123456789abcdef xxxxxxxxxxxxxxxx
2236 0123456789       yyyy
2237 * Record 9                          
2238 0123456789abcdef xxxxxxxxxxxxxxxxxx
2239 0123456789       yy
2240 * Record 10                         
2241 0123456789abcdef xxxxxxxxxxxxxxxxxxxx
2242 0123456789       
2243
2244 \pset format wrapped
2245 execute q;
2246 * Record 1                          
2247 0123456789abcdef xx
2248 0123456789       yyyyyyyyyyyyyyyyyy
2249 * Record 2                          
2250 0123456789abcdef xxxx
2251 0123456789       yyyyyyyyyyyyyyyy
2252 * Record 3                          
2253 0123456789abcdef xxxxxx
2254 0123456789       yyyyyyyyyyyyyy
2255 * Record 4                          
2256 0123456789abcdef xxxxxxxx
2257 0123456789       yyyyyyyyyyyy
2258 * Record 5                          
2259 0123456789abcdef xxxxxxxxxx
2260 0123456789       yyyyyyyyyy
2261 * Record 6                          
2262 0123456789abcdef xxxxxxxxxxxx
2263 0123456789       yyyyyyyy
2264 * Record 7                          
2265 0123456789abcdef xxxxxxxxxxxxxx
2266 0123456789       yyyyyy
2267 * Record 8                          
2268 0123456789abcdef xxxxxxxxxxxxxxxx
2269 0123456789       yyyy
2270 * Record 9                          
2271 0123456789abcdef xxxxxxxxxxxxxxxxxx
2272 0123456789       yy
2273 * Record 10                         
2274 0123456789abcdef xxxxxxxxxxxxxxxxxxxx
2275 0123456789       
2276
2277 \pset border 1
2278 \pset format unaligned
2279 execute q;
2280 0123456789abcdef|xx
2281 0123456789|yyyyyyyyyyyyyyyyyy
2282
2283 0123456789abcdef|xxxx
2284 0123456789|yyyyyyyyyyyyyyyy
2285
2286 0123456789abcdef|xxxxxx
2287 0123456789|yyyyyyyyyyyyyy
2288
2289 0123456789abcdef|xxxxxxxx
2290 0123456789|yyyyyyyyyyyy
2291
2292 0123456789abcdef|xxxxxxxxxx
2293 0123456789|yyyyyyyyyy
2294
2295 0123456789abcdef|xxxxxxxxxxxx
2296 0123456789|yyyyyyyy
2297
2298 0123456789abcdef|xxxxxxxxxxxxxx
2299 0123456789|yyyyyy
2300
2301 0123456789abcdef|xxxxxxxxxxxxxxxx
2302 0123456789|yyyy
2303
2304 0123456789abcdef|xxxxxxxxxxxxxxxxxx
2305 0123456789|yy
2306
2307 0123456789abcdef|xxxxxxxxxxxxxxxxxxxx
2308 0123456789|
2309 \pset format aligned
2310 execute q;
2311 -[ RECORD 1 ]----+---------------------
2312 0123456789abcdef | xx
2313 0123456789       | yyyyyyyyyyyyyyyyyy
2314 -[ RECORD 2 ]----+---------------------
2315 0123456789abcdef | xxxx
2316 0123456789       | yyyyyyyyyyyyyyyy
2317 -[ RECORD 3 ]----+---------------------
2318 0123456789abcdef | xxxxxx
2319 0123456789       | yyyyyyyyyyyyyy
2320 -[ RECORD 4 ]----+---------------------
2321 0123456789abcdef | xxxxxxxx
2322 0123456789       | yyyyyyyyyyyy
2323 -[ RECORD 5 ]----+---------------------
2324 0123456789abcdef | xxxxxxxxxx
2325 0123456789       | yyyyyyyyyy
2326 -[ RECORD 6 ]----+---------------------
2327 0123456789abcdef | xxxxxxxxxxxx
2328 0123456789       | yyyyyyyy
2329 -[ RECORD 7 ]----+---------------------
2330 0123456789abcdef | xxxxxxxxxxxxxx
2331 0123456789       | yyyyyy
2332 -[ RECORD 8 ]----+---------------------
2333 0123456789abcdef | xxxxxxxxxxxxxxxx
2334 0123456789       | yyyy
2335 -[ RECORD 9 ]----+---------------------
2336 0123456789abcdef | xxxxxxxxxxxxxxxxxx
2337 0123456789       | yy
2338 -[ RECORD 10 ]---+---------------------
2339 0123456789abcdef | xxxxxxxxxxxxxxxxxxxx
2340 0123456789       | 
2341
2342 \pset format wrapped
2343 execute q;
2344 -[ RECORD 1 ]----+---------------------
2345 0123456789abcdef | xx
2346 0123456789       | yyyyyyyyyyyyyyyyyy
2347 -[ RECORD 2 ]----+---------------------
2348 0123456789abcdef | xxxx
2349 0123456789       | yyyyyyyyyyyyyyyy
2350 -[ RECORD 3 ]----+---------------------
2351 0123456789abcdef | xxxxxx
2352 0123456789       | yyyyyyyyyyyyyy
2353 -[ RECORD 4 ]----+---------------------
2354 0123456789abcdef | xxxxxxxx
2355 0123456789       | yyyyyyyyyyyy
2356 -[ RECORD 5 ]----+---------------------
2357 0123456789abcdef | xxxxxxxxxx
2358 0123456789       | yyyyyyyyyy
2359 -[ RECORD 6 ]----+---------------------
2360 0123456789abcdef | xxxxxxxxxxxx
2361 0123456789       | yyyyyyyy
2362 -[ RECORD 7 ]----+---------------------
2363 0123456789abcdef | xxxxxxxxxxxxxx
2364 0123456789       | yyyyyy
2365 -[ RECORD 8 ]----+---------------------
2366 0123456789abcdef | xxxxxxxxxxxxxxxx
2367 0123456789       | yyyy
2368 -[ RECORD 9 ]----+---------------------
2369 0123456789abcdef | xxxxxxxxxxxxxxxxxx
2370 0123456789       | yy
2371 -[ RECORD 10 ]---+---------------------
2372 0123456789abcdef | xxxxxxxxxxxxxxxxxxxx
2373 0123456789       | 
2374
2375 \pset border 2
2376 \pset format unaligned
2377 execute q;
2378 0123456789abcdef|xx
2379 0123456789|yyyyyyyyyyyyyyyyyy
2380
2381 0123456789abcdef|xxxx
2382 0123456789|yyyyyyyyyyyyyyyy
2383
2384 0123456789abcdef|xxxxxx
2385 0123456789|yyyyyyyyyyyyyy
2386
2387 0123456789abcdef|xxxxxxxx
2388 0123456789|yyyyyyyyyyyy
2389
2390 0123456789abcdef|xxxxxxxxxx
2391 0123456789|yyyyyyyyyy
2392
2393 0123456789abcdef|xxxxxxxxxxxx
2394 0123456789|yyyyyyyy
2395
2396 0123456789abcdef|xxxxxxxxxxxxxx
2397 0123456789|yyyyyy
2398
2399 0123456789abcdef|xxxxxxxxxxxxxxxx
2400 0123456789|yyyy
2401
2402 0123456789abcdef|xxxxxxxxxxxxxxxxxx
2403 0123456789|yy
2404
2405 0123456789abcdef|xxxxxxxxxxxxxxxxxxxx
2406 0123456789|
2407 \pset format aligned
2408 execute q;
2409 +-[ RECORD 1 ]-----+----------------------+
2410 | 0123456789abcdef | xx                   |
2411 | 0123456789       | yyyyyyyyyyyyyyyyyy   |
2412 +-[ RECORD 2 ]-----+----------------------+
2413 | 0123456789abcdef | xxxx                 |
2414 | 0123456789       | yyyyyyyyyyyyyyyy     |
2415 +-[ RECORD 3 ]-----+----------------------+
2416 | 0123456789abcdef | xxxxxx               |
2417 | 0123456789       | yyyyyyyyyyyyyy       |
2418 +-[ RECORD 4 ]-----+----------------------+
2419 | 0123456789abcdef | xxxxxxxx             |
2420 | 0123456789       | yyyyyyyyyyyy         |
2421 +-[ RECORD 5 ]-----+----------------------+
2422 | 0123456789abcdef | xxxxxxxxxx           |
2423 | 0123456789       | yyyyyyyyyy           |
2424 +-[ RECORD 6 ]-----+----------------------+
2425 | 0123456789abcdef | xxxxxxxxxxxx         |
2426 | 0123456789       | yyyyyyyy             |
2427 +-[ RECORD 7 ]-----+----------------------+
2428 | 0123456789abcdef | xxxxxxxxxxxxxx       |
2429 | 0123456789       | yyyyyy               |
2430 +-[ RECORD 8 ]-----+----------------------+
2431 | 0123456789abcdef | xxxxxxxxxxxxxxxx     |
2432 | 0123456789       | yyyy                 |
2433 +-[ RECORD 9 ]-----+----------------------+
2434 | 0123456789abcdef | xxxxxxxxxxxxxxxxxx   |
2435 | 0123456789       | yy                   |
2436 +-[ RECORD 10 ]----+----------------------+
2437 | 0123456789abcdef | xxxxxxxxxxxxxxxxxxxx |
2438 | 0123456789       |                      |
2439 +------------------+----------------------+
2440
2441 \pset format wrapped
2442 execute q;
2443 +-[ RECORD 1 ]-----+-------------------+
2444 | 0123456789abcdef | xx                |
2445 | 0123456789       | yyyyyyyyyyyyyyyyy |
2446 |                  ; y                 |
2447 +-[ RECORD 2 ]-----+-------------------+
2448 | 0123456789abcdef | xxxx              |
2449 | 0123456789       | yyyyyyyyyyyyyyyy  |
2450 +-[ RECORD 3 ]-----+-------------------+
2451 | 0123456789abcdef | xxxxxx            |
2452 | 0123456789       | yyyyyyyyyyyyyy    |
2453 +-[ RECORD 4 ]-----+-------------------+
2454 | 0123456789abcdef | xxxxxxxx          |
2455 | 0123456789       | yyyyyyyyyyyy      |
2456 +-[ RECORD 5 ]-----+-------------------+
2457 | 0123456789abcdef | xxxxxxxxxx        |
2458 | 0123456789       | yyyyyyyyyy        |
2459 +-[ RECORD 6 ]-----+-------------------+
2460 | 0123456789abcdef | xxxxxxxxxxxx      |
2461 | 0123456789       | yyyyyyyy          |
2462 +-[ RECORD 7 ]-----+-------------------+
2463 | 0123456789abcdef | xxxxxxxxxxxxxx    |
2464 | 0123456789       | yyyyyy            |
2465 +-[ RECORD 8 ]-----+-------------------+
2466 | 0123456789abcdef | xxxxxxxxxxxxxxxx  |
2467 | 0123456789       | yyyy              |
2468 +-[ RECORD 9 ]-----+-------------------+
2469 | 0123456789abcdef | xxxxxxxxxxxxxxxxx |
2470 |                  ; x                 |
2471 | 0123456789       | yy                |
2472 +-[ RECORD 10 ]----+-------------------+
2473 | 0123456789abcdef | xxxxxxxxxxxxxxxxx |
2474 |                  ; xxx               |
2475 | 0123456789       |                   |
2476 +------------------+-------------------+
2477
2478 deallocate q;
2479 prepare q as select ' | = | lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (&' as " | -- | 012345678 9abc def!*@#&!@(*&*~~_+-=\ \", '11' as "0123456789", 11 as int from generate_series(1,10) as n;
2480 \pset format asciidoc
2481 \pset expanded off
2482 \pset border 0
2483 execute q;
2484
2485 [options="header",cols="<l,<l,>l",frame="none",grid="none"]
2486 |====
2487 ^l| \| -- \| 012345678 9abc def!*@#&!@(*&*~~_+-=\ \ ^l|0123456789 ^l|int
2488 | \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (& |11 |11
2489 | \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (& |11 |11
2490 | \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (& |11 |11
2491 | \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (& |11 |11
2492 | \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (& |11 |11
2493 | \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (& |11 |11
2494 | \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (& |11 |11
2495 | \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (& |11 |11
2496 | \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (& |11 |11
2497 | \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (& |11 |11
2498 |====
2499
2500 ....
2501 (10 rows)
2502 ....
2503 \pset border 1
2504 execute q;
2505
2506 [options="header",cols="<l,<l,>l",frame="none"]
2507 |====
2508 ^l| \| -- \| 012345678 9abc def!*@#&!@(*&*~~_+-=\ \ ^l|0123456789 ^l|int
2509 | \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (& |11 |11
2510 | \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (& |11 |11
2511 | \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (& |11 |11
2512 | \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (& |11 |11
2513 | \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (& |11 |11
2514 | \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (& |11 |11
2515 | \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (& |11 |11
2516 | \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (& |11 |11
2517 | \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (& |11 |11
2518 | \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (& |11 |11
2519 |====
2520
2521 ....
2522 (10 rows)
2523 ....
2524 \pset border 2
2525 execute q;
2526
2527 [options="header",cols="<l,<l,>l",frame="all",grid="all"]
2528 |====
2529 ^l| \| -- \| 012345678 9abc def!*@#&!@(*&*~~_+-=\ \ ^l|0123456789 ^l|int
2530 | \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (& |11 |11
2531 | \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (& |11 |11
2532 | \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (& |11 |11
2533 | \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (& |11 |11
2534 | \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (& |11 |11
2535 | \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (& |11 |11
2536 | \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (& |11 |11
2537 | \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (& |11 |11
2538 | \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (& |11 |11
2539 | \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (& |11 |11
2540 |====
2541
2542 ....
2543 (10 rows)
2544 ....
2545 \pset expanded on
2546 \pset border 0
2547 execute q;
2548
2549 [cols="h,l",frame="none",grid="none"]
2550 |====
2551 2+^|Record 1
2552 <l| \| -- \| 012345678 9abc def!*@#&!@(*&*~~_+-=\ \ <l| \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (&
2553 <l|0123456789 <l|11
2554 <l|int >l|11
2555 2+^|Record 2
2556 <l| \| -- \| 012345678 9abc def!*@#&!@(*&*~~_+-=\ \ <l| \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (&
2557 <l|0123456789 <l|11
2558 <l|int >l|11
2559 2+^|Record 3
2560 <l| \| -- \| 012345678 9abc def!*@#&!@(*&*~~_+-=\ \ <l| \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (&
2561 <l|0123456789 <l|11
2562 <l|int >l|11
2563 2+^|Record 4
2564 <l| \| -- \| 012345678 9abc def!*@#&!@(*&*~~_+-=\ \ <l| \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (&
2565 <l|0123456789 <l|11
2566 <l|int >l|11
2567 2+^|Record 5
2568 <l| \| -- \| 012345678 9abc def!*@#&!@(*&*~~_+-=\ \ <l| \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (&
2569 <l|0123456789 <l|11
2570 <l|int >l|11
2571 2+^|Record 6
2572 <l| \| -- \| 012345678 9abc def!*@#&!@(*&*~~_+-=\ \ <l| \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (&
2573 <l|0123456789 <l|11
2574 <l|int >l|11
2575 2+^|Record 7
2576 <l| \| -- \| 012345678 9abc def!*@#&!@(*&*~~_+-=\ \ <l| \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (&
2577 <l|0123456789 <l|11
2578 <l|int >l|11
2579 2+^|Record 8
2580 <l| \| -- \| 012345678 9abc def!*@#&!@(*&*~~_+-=\ \ <l| \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (&
2581 <l|0123456789 <l|11
2582 <l|int >l|11
2583 2+^|Record 9
2584 <l| \| -- \| 012345678 9abc def!*@#&!@(*&*~~_+-=\ \ <l| \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (&
2585 <l|0123456789 <l|11
2586 <l|int >l|11
2587 2+^|Record 10
2588 <l| \| -- \| 012345678 9abc def!*@#&!@(*&*~~_+-=\ \ <l| \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (&
2589 <l|0123456789 <l|11
2590 <l|int >l|11
2591 |====
2592 \pset border 1
2593 execute q;
2594
2595 [cols="h,l",frame="none"]
2596 |====
2597 2+^|Record 1
2598 <l| \| -- \| 012345678 9abc def!*@#&!@(*&*~~_+-=\ \ <l| \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (&
2599 <l|0123456789 <l|11
2600 <l|int >l|11
2601 2+^|Record 2
2602 <l| \| -- \| 012345678 9abc def!*@#&!@(*&*~~_+-=\ \ <l| \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (&
2603 <l|0123456789 <l|11
2604 <l|int >l|11
2605 2+^|Record 3
2606 <l| \| -- \| 012345678 9abc def!*@#&!@(*&*~~_+-=\ \ <l| \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (&
2607 <l|0123456789 <l|11
2608 <l|int >l|11
2609 2+^|Record 4
2610 <l| \| -- \| 012345678 9abc def!*@#&!@(*&*~~_+-=\ \ <l| \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (&
2611 <l|0123456789 <l|11
2612 <l|int >l|11
2613 2+^|Record 5
2614 <l| \| -- \| 012345678 9abc def!*@#&!@(*&*~~_+-=\ \ <l| \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (&
2615 <l|0123456789 <l|11
2616 <l|int >l|11
2617 2+^|Record 6
2618 <l| \| -- \| 012345678 9abc def!*@#&!@(*&*~~_+-=\ \ <l| \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (&
2619 <l|0123456789 <l|11
2620 <l|int >l|11
2621 2+^|Record 7
2622 <l| \| -- \| 012345678 9abc def!*@#&!@(*&*~~_+-=\ \ <l| \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (&
2623 <l|0123456789 <l|11
2624 <l|int >l|11
2625 2+^|Record 8
2626 <l| \| -- \| 012345678 9abc def!*@#&!@(*&*~~_+-=\ \ <l| \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (&
2627 <l|0123456789 <l|11
2628 <l|int >l|11
2629 2+^|Record 9
2630 <l| \| -- \| 012345678 9abc def!*@#&!@(*&*~~_+-=\ \ <l| \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (&
2631 <l|0123456789 <l|11
2632 <l|int >l|11
2633 2+^|Record 10
2634 <l| \| -- \| 012345678 9abc def!*@#&!@(*&*~~_+-=\ \ <l| \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (&
2635 <l|0123456789 <l|11
2636 <l|int >l|11
2637 |====
2638 \pset border 2
2639 execute q;
2640
2641 [cols="h,l",frame="all",grid="all"]
2642 |====
2643 2+^|Record 1
2644 <l| \| -- \| 012345678 9abc def!*@#&!@(*&*~~_+-=\ \ <l| \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (&
2645 <l|0123456789 <l|11
2646 <l|int >l|11
2647 2+^|Record 2
2648 <l| \| -- \| 012345678 9abc def!*@#&!@(*&*~~_+-=\ \ <l| \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (&
2649 <l|0123456789 <l|11
2650 <l|int >l|11
2651 2+^|Record 3
2652 <l| \| -- \| 012345678 9abc def!*@#&!@(*&*~~_+-=\ \ <l| \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (&
2653 <l|0123456789 <l|11
2654 <l|int >l|11
2655 2+^|Record 4
2656 <l| \| -- \| 012345678 9abc def!*@#&!@(*&*~~_+-=\ \ <l| \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (&
2657 <l|0123456789 <l|11
2658 <l|int >l|11
2659 2+^|Record 5
2660 <l| \| -- \| 012345678 9abc def!*@#&!@(*&*~~_+-=\ \ <l| \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (&
2661 <l|0123456789 <l|11
2662 <l|int >l|11
2663 2+^|Record 6
2664 <l| \| -- \| 012345678 9abc def!*@#&!@(*&*~~_+-=\ \ <l| \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (&
2665 <l|0123456789 <l|11
2666 <l|int >l|11
2667 2+^|Record 7
2668 <l| \| -- \| 012345678 9abc def!*@#&!@(*&*~~_+-=\ \ <l| \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (&
2669 <l|0123456789 <l|11
2670 <l|int >l|11
2671 2+^|Record 8
2672 <l| \| -- \| 012345678 9abc def!*@#&!@(*&*~~_+-=\ \ <l| \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (&
2673 <l|0123456789 <l|11
2674 <l|int >l|11
2675 2+^|Record 9
2676 <l| \| -- \| 012345678 9abc def!*@#&!@(*&*~~_+-=\ \ <l| \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (&
2677 <l|0123456789 <l|11
2678 <l|int >l|11
2679 2+^|Record 10
2680 <l| \| -- \| 012345678 9abc def!*@#&!@(*&*~~_+-=\ \ <l| \| = \| lkjsafi\\/ /oeu rio)(!@&*#)*(!&@*) \ (&
2681 <l|0123456789 <l|11
2682 <l|int >l|11
2683 |====
2684 deallocate q;
2685 -- SHOW_CONTEXT
2686 \set SHOW_CONTEXT never
2687 do $$
2688 begin
2689   raise notice 'foo';
2690   raise exception 'bar';
2691 end $$;
2692 NOTICE:  foo
2693 ERROR:  bar
2694 \set SHOW_CONTEXT errors
2695 do $$
2696 begin
2697   raise notice 'foo';
2698   raise exception 'bar';
2699 end $$;
2700 NOTICE:  foo
2701 ERROR:  bar
2702 CONTEXT:  PL/pgSQL function inline_code_block line 4 at RAISE
2703 \set SHOW_CONTEXT always
2704 do $$
2705 begin
2706   raise notice 'foo';
2707   raise exception 'bar';
2708 end $$;
2709 NOTICE:  foo
2710 CONTEXT:  PL/pgSQL function inline_code_block line 3 at RAISE
2711 ERROR:  bar
2712 CONTEXT:  PL/pgSQL function inline_code_block line 4 at RAISE
Unnamed repository; edit this file 'description' to name the repository.