SELECT ID, string_agg(NAME, ',') FROM table GROUP BY ID; Register as a new user and use Qiita more conveniently You get articles that match your needsYou can efficiently read back useful informationYou can use dark themeWhat you can do with signing up