Insert array data to table : Array Column Insert « Array « PostgreSQL

1. PostgreSQL
2. Array
3. Array Column Insert

Insert array data to table

postgres=# CREATE TABLE arr(f1 int[], f2 int[]);
CREATE TABLE
postgres=#
postgres=# INSERT INTO arr VALUES (ARRAY[[1,2],[3,4]], ARRAY[[5,6],[7,8]]);
INSERT 0 1
postgres=#
postgres=# SELECT ARRAY[f1, f2, '{{9,10},{11,12}}'::int[]] FROM arr;
                     array
------------------------------------------------
 {{{1,2},{3,4}},{{5,6},{7,8}},{{9,10},{11,12}}}
(1 row)

postgres=#
postgres=# SELECT ARRAY(SELECT oid FROM pg_proc WHERE proname LIKE 'bytea%');
                               ?column?
-----------------------------------------------------------------------
 {2011,1954,1948,1952,1951,1244,1950,2005,1949,1953,2006,31,2412,2413}
(1 row)

postgres=#
postgres=# drop table arr;
DROP TABLE
postgres=#
           
       

Related examples in the same category