Re: How to implement word wrap - Mailing list pgsql-general

2010/3/29 Andrus <kobruleht2@hot.ee>

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.

--

No, what you've done is asked it to insert 'aa aa aa aa aa aa aa aa aa aa'.

I suspect you're looking for:

INSERT INTO test SELECT 'aa' FROM generate_series(1,10);

Regards

Thom