8

More than 5 years have passed since last update.

Postgres で group by + array_to_stringをする。

postgres

Posted at 2014-05-01

以下のtableを

ID	NAME
1	AAA
1	BBB
2	CCC
2	DDD
2	AAA
3	EEE

以下のようにするには。

ID	NAME
1	AAA,BBB,CCC
2	CCC,DDD,AAA
3	EEE

SELECT ID, string_agg(NAME, ',')
FROM table
GROUP BY ID;

Postgresのバージョンは9.0

8

Register as a new user and use Qiita more conveniently

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up

8