How to implement word wrap - Mailing list pgsql-general

From Andrus
Subject How to implement word wrap
Date
Msg-id 428B8E529EAF47D4A7D4599141E65B67@andrusnotebook
Whole thread Raw
Responses Re: How to implement word wrap
Re: How to implement word wrap
List pgsql-general
Database column contains large string without line feeds.
How to split it with word wrap between words ?
I tried to implement word wrap using

create temp table test (line char(7));
insert into test select repeat('aa ',10);
select * from test;

Expected result is that table test contains multiple rows and every row
contains two words:

aa aa

Instead I got string too long exception.

How to implement word wrap in PostgreSql if  string contains words of any
size separated by spaces?

Andrus.


pgsql-general by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: How long will the query take
Next
From: Ogden
Date:
Subject: Re: Warm Standby Setup Documentation