dv4a7w
Last Updated: February 25, 2016
·
1.303K
· felipeelias
F6faa607e4f541da71fbf8aea6f99a7a

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"
Say Thanks
Respond
Awesome Job

B6c77ad0 c95b 11e7 8263 8f89080b8db6
Ruby Developer Backend
·
Austria (Vienna or Linz)
·
Full Time