select a list of column values directly into an array - Mailing list pgsql-general

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!