CODE EXAMPLE FOR SQL

insert array postgresql

create table example(arr smallint[]);
insert into example(arr) values('{1, 2, 3}');
-- alternative syntax
create table example(arr smallint[]);
insert into example(arr) values(array[1, 2, 3]);