postgresqlHow do I split a string in PostgreSQL?

PostgreSQL provides a built-in function to split a string into an array of substrings based on a specified delimiter. This function is called string_to_array().

The syntax for the string_to_array() function is as follows:

string_to_array(string text, delimiter text)

Example

SELECT string_to_array('1,2,3,4,5', ',');

-- Output:
{"1","2","3","4","5"}

The string_to_array() function takes two arguments:

1. string - The string to be split.
2. delimiter - The character or characters used to separate the string.

The string_to_array() function returns an array of substrings.

Helpful links

• PostgreSQL Documentation - String Functions and Operators
• PostgreSQL Documentation - String-to-Array

Edit this code on GitHub