Table of Contents

• Splitting a String into Columns
• Splitting a String into an Array
• Splitting a String into Rows

1. Splitting a String into Columns

The following SQL query splits a comma-separated string into individual columns.

WITH test AS (SELECT 'Seoul,Daegu,Busan,Daejeon,Incheon,Gwangju' cities)
SELECT 
    split_part(cities, ',', 1) AS "1", 
    split_part(cities, ',', 2) AS "2", 
    split_part(cities, ',', 3) AS "3", 
    split_part(cities, ',', 4) AS "4", 
    split_part(cities, ',', 5) AS "5", 
    split_part(cities, ',', 6) AS "6" 
FROM test;

2. Splitting a String into an Array

The following SQL query converts a comma-separated string into an array.

WITH test AS (SELECT 'Seoul,Daegu,Busan,Daejeon,Incheon,Gwangju' cities)
SELECT string_to_array(cities, ',') FROM test;

3. Splitting a String into Rows

The following SQL query converts a comma-separated string into multiple rows.

WITH test AS (SELECT 'Seoul,Daegu,Busan,Daejeon,Incheon,Gwangju' cities)
SELECT unnest(string_to_array(cities, ',')) FROM test;