yugabyte=# CREATE TABLE stuff (names TEXT[]);
CREATE TABLE
yugabyte=# INSERT INTO stuff VALUES (ARRAY['Jim', 'Bryan', 'Mike', 'Andrius', 'Alex']);
INSERT 0 1
yugabyte=# SELECT * FROM stuff;
names
-------------------------------
{Jim,Bryan,Mike,Andrius,Alex}
(1 row)
yugabyte=# SELECT unnest(names) FROM stuff ORDER BY 1;;
unnest
---------
Alex
Andrius
Bryan
Jim
Mike
(5 rows)