dv4a7w
Last Updated: February 08, 2019
·
1.696K
· felipeelias

Select array as rows in postgresql

If you have an array and want to create rows from each element, use:

SELECT unnest(ARRAY['one', 'two', 'three'])

And get

unnest
------
"one"
"two"
"three"