psql append string on update code example

Example: postgress append string in select

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