String concatenation in PosgreSQL

SELECT 'a' || 'b'

SELECT concat('a', 'b')

SELECT concat_ws(',', 'a', 'b')

concat_ws stands for concatenate with separator.

Know more:

• String concatenation aggregation in PostgreSQL

References:

• https://www.postgresqltutorial.com/postgresql-string-functions/postgresql-concat-function/