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!