PostgreSQL Function Reference

STRING_AGG
Concatenates a set of strings with a delimiter.
PostgreSQL 17.5
STRING_AGG(expression, delimiter)
expression
The string expression.
delimiter
The delimiter to insert.
Examples
PostgreSQL 17.5
SELECT STRING_AGG(member_name, ', ')
FROM FamilyMembers;