SQL

String concatenation in PostgreSQL

-- with functions
CONCAT(first_name,' ', last_name) AS full_name;

-- with string concatenation operator
SELECT first_name || ' ' || last_name AS full_name FROM customer;

-- String concatenation with a non-string input
SELECT customer_id || ': ' || first_name || ' ' || last_name AS full_name
FROM customer;

postgresql concat string with separator

SELECT
	concat_ws (', ', last_name, first_name) AS full_name
FROM
	customer
ORDER BY
	last_name;Code language: SQL (Structured Query Language) (sql)