concate postgres ato string_agg

SELECT * FROM public.group_by_ex
GO

SELECT CITY, STATE, string_agg(member, ', '), SUM(DONATION) FROM group_by_ex
GROUP BY CITY,STATE

Tweet