Need text wrapping inside a column to avoid record wrapping (tabular output of 'select')

On 2018-Jul-25, David Gauthier wrote:

Hi:

psql (9.6.7, server 9.1.9) on RHEL6

In order to avoid record wrapping in the tabular output of a "select"
statement, I need to limit the width of certain columns. For those
columns, I would like to have text wrapping so as not to lose any
information (IOW, I don't want to simply truncatate and lose info).

\pset format wrapped

It doesn't break on whitespace though.

$ 999,00 │ Nine hundred ninety nine dollars and z…
│…ero cents
$ 1.000,…│ One thousand dollars and zero cents
… 00 │

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

On 07/25/2018 09:40 AM, David Gauthier wrote:

Hi:

psql (9.6.7, server 9.1.9)  on RHEL6

In order to avoid record wrapping in the tabular output of a "select"
statement, I need to limit the width of certain columns.  For those
columns, I would like to have text wrapping so as not to lose any
information (IOW, I don't want to simply truncatate and lose info).

Example:

name           |age  |life_story
|favorite_color
---------------+-----+------------------------------------------+--------------
madame marie   | 123 | She was born a long time ago, blah, blah,| yellow
               |     | blah, blah, blah, blah, blah, blah, blah,|
               |     | blah, more-more-mmore-more-more,         |
               |     | andmore-andmore-andmore-andmore, blah,   |
               |     | blah, blah, blah, blah, blah, blah, blah |
               |     | and now she's 123 years old              |
---------------+-----+------------------------------------------+---------------

... that sort of thing.  Also, line breaks in the "life_story" where
they make sense, like on spaces, as you see in lines 3&4 of that column

Is there an easy way to configure PG to do this ?

In psql:

create table wrap_test(name varchar, age integer, life_story varchar,
favorite_color varchar);

insert into wrap_test values ('madame marie', 123, 'She was born a long
time ago, blah, blah, yellow eblah, blah, blah, blah, blah, blah, blah,
blah, more-more-mmore-more-more, andmore-andmore-andmore-andmore, blah,
blah, blah, blah, blah, blah, blah, blah and now she''s 123 years old',
'yellow');

\pset format wrapped

select * from wrap_test ;

I am not showing output as email client distorts it.

Thanks in Advance !

--
Adrian Klaver
adrian.klaver@aklaver.com

That does it. Good enough, despite the non-white space wrapping thing.
Thanks !

On Wed, Jul 25, 2018 at 12:53 PM, Adrian Klaver <adrian.klaver@aklaver.com>
wrote: