TEXT column contains multi-line text.
How to split it to multiple rows so that every line is in separate row ?
Code below should return two rows,
Line 1
Line 2
Solution should work starting at 8.1
Should generate_series or pgsql procedure used or any other idea?
Andrus.
create temp table test ( test text ) on commit drop;
insert into test values( 'Line 1' ||chr(13)||'Line2');
create temp table test2 ( test text ) on commit drop;
-- todo: split test to multiple rows
insert into test2 select * from test;
select * from test2;