Current Result

I would like to convert these multiple orders into individual rows in POSTGRES

Required Result

CodePudding user response：

Convert comma-separated text to array and use unnest function:

SELECT id, unnest(string_to_array[orders], ',')) FROM your_table;

CodePudding user response：

Solution for you problem:

SELECT ID,UNNEST(STRING_TO_ARRAY(Orders, ',')) Orders
FROM Table1;
 

db fiddle link

Unnest: It is an array function which expands an array into set of rows.

Syntax:

unnest ( anyarray )    

string_to_array: It is also an array function which splits string into array elements using supplied delimiter and optional null-string.

Here optional null-string parameter is used to replace the sub-strings in the input which matches the null-string parameter value with NULL value in the output or final array.

Syntax:

string_to_array(text, text [, text])

For more information on unnest and string_to_array syntax follow the below link:

https://www.postgresql.org/docs/14/functions-array.html

https://www.postgresql.org/docs/9.1/functions-array.html