> What I've tried: > bustrac=# alter table people alter column email set data type varchar(64) []; > ERROR: column "email" cannot be cast automatically to type character > varying[] > HINT: You might need to specify "USING email::character varying(64)[]".
What I forgot to mention is that the current datatype is varchar(64) and I want to make it an array.