More than 5 years have passed since last update.

【PostgreSQL】1:Nのテーブルのカラムを配列で取得する

Last updated at 2016-04-30Posted at 2016-04-30

SQL一発で取れるのは良いですね。

SELECT
  id,
  column1,
  column2,
  array(SELECT column3 FROM table2 WHERE table2.table1_id = table1.id) as culumn3
FROM
  table1;