PostgreSQL Tutorial PostgreSQL Advanced PostgreSQL Database Account Management PostgreSQL References
PostgreSQL Tutorial PostgreSQL Advanced PostgreSQL Database Account Management PostgreSQL References

PostgreSQL CONCAT() Function



The PostgreSQL CONCAT() function is used to concatenate two or more expressions together. This function may have one or more arguments. If any of the expressions is a NULL, this function ignores NULL values during concatenation.

Syntax

CONCAT(expr1, expr2, ... expr_n)

Parameters

expr1, expr2, ... expr_n Required. Specify the expressions to concatenate together.

Return Value

Returns the concatenated string.

Example 1:

The example below shows the usage of CONCAT() function.

SELECT CONCAT('SQL ', 'Tutorial');
Result: 'SQL Tutorial'

SELECT CONCAT('Learning ', 'SQL ', 'is ', 'fun!.');
Result: 'Learning SQL is fun!.'

SELECT CONCAT('Sum is ', 25 + 25);
Result: 'Sum is 50'

SELECT CONCAT('Alpha ', 'Beta', ' Gamma');
Result: 'Alpha Beta Gamma'

SELECT CONCAT('Alpha ', 'Beta', NULL, ' Gamma');
Result: 'Alpha Beta Gamma'

Example 2:

Consider a database table called Employee with the following records:

EmpIDFirstNameLastName
1JohnSmith
2MarryKnight
3JoWilliams
4KimFischer
5RameshGupta
6HuangZhang

In the query below, the CONCAT() function is used to concatenate records of column FirstName and column LastName.

SELECT *, CONCAT(FirstName, ' ', LastName) AS FullName FROM Employee;

This will produce the result as shown below:

EmpIDFirstNameLastNameFullName
1JohnSmithJohn Smith
2MarryKnightMarry Knight
3JoWilliamsJo Williams
4KimFischerKim Fischer
5RameshGuptaRamesh Gupta
6HuangZhangHuang Zhang

❮ PostgreSQL Functions