postgres=# CREATE TABLE t1 (id serial, myarray int[]);

CREATE TABLE

postgres=# INSERT INTO t1(myarray) VALUES('{1, 2, 4}');

INSERT 0 1

postgres=# SELECT * FROM t1;

 id | myarray 

----+---------

  1 | {1,2,4}

(1 row)

postgres=# SELECT id, myarray[1], myarray[2], myarray[3] FROM t1;

 id | myarray | myarray | myarray 

----+---------+---------+---------

  1 |       1 |       2 |       4

(1 row)