PostgreSQL Function Reference

CONCAT
Concatenates a variable number of arguments into a single string. Null values are ignored.
PostgreSQL 17.5
CONCAT(expression [, ...])
expression
Any expression to concatenate.
Examples
PostgreSQL 17.5
SELECT CONCAT('Post', 'greSQL')