Postgres 将 Array 转换成 row 用 UNNEST。 示例 SELECT UNNEST(ARRAY[1,2,3]); unnest -------- 1 2 3 (3 rows) 引用 How to split array into rows in Postgresql 2022-01-06 14:37 https://luo3.org.cn/posts/snippets/convert-array-to-row-record-in-postgres/ Yongz Luo snippets #postgres