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