Skip site navigation (1) Skip section navigation (2)

Re: How to implement word wrap

From: Thom Brown <thombrown(at)gmail(dot)com>
To: Andrus <kobruleht2(at)hot(dot)ee>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to implement word wrap
Date: 2010-03-29 16:42:47
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
2010/3/29 Andrus <kobruleht2(at)hot(dot)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);



In response to


pgsql-general by date

Next:From: Andreas KretschmerDate: 2010-03-29 16:43:09
Subject: Re: How to implement word wrap
Previous:From: Chris BarnesDate: 2010-03-29 16:42:46
Subject: Processor speed relative to postgres transactions per second

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group