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"Written by Felipe Elias Philipp
Related protips
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best
#Postgres
Authors
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#