How to get an array from a table in postgresql?

Question

IDE

Let's admit there is a table test:
field
---------
1
2
3
There is a request select field from test;
How to get not every row of the table, but something like array[1,2,3]. That is one array. Thanks in advance for your reply.

Answer 1

Official.
Atollic TrueSTUDIO for STM32

Answer 2

Personally, I don't use an IDE at all.
I decided for myself that there are no normal environments for STM32.
In my blog , I described for myself in the form of a memo how to deploy a workspace under Linux, I think you can do the same on Windows.
In short, then:
1. I generate a basic project with peripheral initialization in STM32CubeMX
2. I write the code in Sublime
3. I compile with the arm-none-eabi-gcc compiler
4. Well, I flash it with the st-link utility

Answer 3

Keil?

Answer 4

select array_agg(field) from test
?