Mega Code Archive
Insert array data to table
<![CDATA[
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=#
]]>