SQL · Array and set-returning functions

string_to_array()

Splits a string into an array. PostgreSQL.

sqlRunnable example sql course

Syntax

string_to_array(text, delimiter)

Example

Open in the lab

SELECT value FROM json_each('[1,2,3]');

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.