Thread: Need text wrapping inside a column to avoid record wrapping (tabularoutput of 'select')
Need text wrapping inside a column to avoid record wrapping (tabularoutput of 'select')
From
David Gauthier
Date:
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 ?
Thanks in Advance !
Re: Need text wrapping inside a column to avoid record wrapping(tabular output of 'select')
From
Alvaro Herrera
Date:
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
Re: Need text wrapping inside a column to avoid record wrapping(tabular output of 'select')
From
Adrian Klaver
Date:
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
Re: Need text wrapping inside a column to avoid record wrapping(tabular output of 'select')
From
David Gauthier
Date:
That does it. Good enough, despite the non-white space wrapping thing.
Thanks !
Thanks !
On Wed, Jul 25, 2018 at 12:53 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
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