postgresql concatenate rows into string code example
Example: postgresql combine values in one field
SELECT movie, string_agg(actor, ', ') AS actor_list
FROM tbl
GROUP BY 1;
SELECT movie, string_agg(actor, ', ') AS actor_list
FROM tbl
GROUP BY 1;