postgresql multiple rows to one column 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;