psql concat strings code example

Example: postgress append string in select

SELECT
   'Concatenation' || ' ' || 'Operator' AS result_string;