Postgres 13

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version

PostgreSQL 13.13 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-20), 64-bit

SELECT 1

create table my_table(my_column integer); 

CREATE TABLE

insert into  my_table(my_column) 
    select unnest( array [1,2,3,4,5] ); 

INSERT 0 5

select* from my_table; 

my_column

1

2

3

4

5

SELECT 5