Postgres 13

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE tab(
   username character varying(100),
   email character varying(100)[]
)

CREATE TABLE


INSERT INTO tab(username, email)
VALUES ('user', '{"a@domain.com", "b@domain.com"}')

INSERT 0 1


SELECT *, email[1], email[2]
FROM tab


username
email
email
email


user
{a@domain.com,b@domain.com}
a@domain.com
b@domain.com



SELECT 1