how to concatenate more than one rows in postgresql 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;