How to convert single row value into another table row in postgresql

Question

Need to insert Table1 Col1 value into Table2 Col1:

Input:

Table1
Col1
1,2,3,4

Output:

Table2
Col1
1
2
3
4

Gordon Linoff · Accepted Answer · 2019-10-25 14:51:56Z

1

Use regexp_split_to_table():

select val
from table1 t1 cross join lateral
     regexp_split_to_table(t1.col1, ',') val;

answered Oct 25, 2019 at 14:51

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1