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.