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; -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general