postgresql combine values in one field
snippet in sql

postgresql combine values in one field

user6877

SELECT movie, string_agg(actor, ', ') AS actor_list
FROM   tbl
GROUP  BY 1;