Revision history [back]

You can use the ARRAY function in PostgreSQL to store the output of a select query in a single array. Here's an example:

SELECT ARRAY(SELECT column FROM table);

This will return the results of the select query as a single array. Replace "column" and "table" with the appropriate values for your query.