SELECT text 'a' AS "text" UNION SELECT 'b'
postgres=# SELECT text 'a' AS "text" UNION SELECT 'b'; text ------ a b (2 rows) postgres=#