test.sql

text/plain
Filename: test.sql
Type: text/plain
Part: 1
Message: Re: Unicode UTF-8 table formatting for psql text output
\pset pager off
\encoding SQL_ASCII

\pset border 0

SELECT 'sit amet,
consectetur
adipisicing
elit' AS "Lorem
ipsum
dolor", 5 AS num;

\pset border 1

SELECT 'sit amet,
consectetur
adipisicing
elit' AS "Lorem
ipsum
dolor", 5 AS num;

\pset border 2

SELECT 'sit amet,
consectetur
adipisicing
elit' AS "Lorem
ipsum
dolor", 5 AS num;

\pset format wrapped

\pset border 0

SELECT
5 AS num,
'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 nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.
Duis
aute
irure
dolor
in
reprehenderit'
AS "Lorem ipsum dolor";

\pset border 1

SELECT
5 AS num,
'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 nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.
Duis
aute
irure
dolor
in
reprehenderit'
AS "Lorem ipsum dolor";

\pset border 2

SELECT
5 AS num,
'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 nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.
Duis
aute
irure
dolor
in
reprehenderit'
AS "Lorem ipsum dolor";