EN
PostgreSQL - CONCAT() function example
0
points
In this article, we would like to show you CONCAT() function example in PostgreSQL.
Quick solution:
SELECT CONCAT('expression1', 'expression2', 'expressionN')
AS "alias_name";
Practical example
In this example
Query:
SELECT CONCAT('Simon', ' ', 'Collins', ' ', '987-654-321')
AS "phone_contact";
Result:
Note:
CONCAT()function can be also used to merge values or search many columns. Go to this article to see more complex examples.