select a list of column values directly into an array

["Gauthier, Dave" <dave.gauthier@xxxxxxxxx>]

Is there a way to select a list of column values directly into an array?

 

create table foo (col1 text);

insert into foo (col1) values (‘aaa’),(‘bbb’),(‘ccc’),(‘ddd’),(‘eee’);

 

I’d like to load up an array with {aaa,bbb,ccc,ddd,eee}, prefferably with a single select statement.

 

Thanks in advance for any help!