postgresql "concatenate rows into string variable" -sqlserver 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;