postgres=# postgres=# postgres=# SELECT ARRAY[1,2] || ARRAY[3,4]; ?column? ----------- {1,2,3,4} (1 row) postgres=#