postgres=# postgres=# SELECT 'abc' || 'def' AS "unspecified"; unspecified ------------- abcdef (1 row) postgres=#