postrgesql concat 2 columns divided by ; code example

Example: postrgesql concat 2 columns divided by ;

SELECT
   'Concatenation' || ' ' || 'Operator' AS result_string;
  
Code language: SQL (Structured Query Language) (sql)