SQL · Array and set-returning functions

array_to_string()

Joins an array into a string. PostgreSQL.

sqlRunnable example sql course

Syntax

array_to_string(array, delimiter)

Example

Open in the lab

SELECT group_concat(value, ',') AS joined 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.