2

How to store the output of a select query in a single array in PostgreSQL?

edit

• sql
• postgresql

asked 2023-01-15 11:00:00 +0000

huitzilopochtli
41 ●4 ●3

edit retag flag offensive close merge delete

add a comment

0

answered 2022-10-29 15:00:00 +0000

david
31 ●16 ●4

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.

edit flag offensive delete link more

add a comment

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss