Let's say you have the array named arr: '{"one", "two"}'.
arr
'{"one", "two"}'
select unnest(arr) as my_column_name;
will turn it into a table. And if you pass select array() a table, it'll turn it into an array.
select array()