string aggexpression delimiter
suggest changeYou can concatenate strings separated by delimiter using the string_agg()
function.
If your individuals
table is:
Name | Age| Country | –– | —| –– | Allie | 15 | USA | Amanda | 14 | USA | Alana | 20 | Russia |
You could write SELECT ... GROUP BY
statement to get names from each country:
SELECT string_agg(name, ', ') AS names, country
FROM individuals
GROUP BY country;
Note that you need to use a GROUP BY
clause because string_agg()
is an aggregate function.
Result:
names | country | —– | —–– | Allie, Amanda | USA | Alana | Russia |
More PostgreSQL aggregate function described here
Found a mistake? Have a question or improvement idea?
Let me know.
Table Of Contents