Languages
[Edit]
EN

PostgreSQL - CONCAT() function example

0 points
Created by:
Dirask JS Member
3460

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:

PostgreSQL - CONCAT() function result in HeidiSQL
PostgreSQL - CONCAT() function result

Note:

CONCAT() function can be also used to merge values or search many columns. Go to this article to see more complex examples.

Related posts

PostgreSQL - Functions

Native Advertising
­čÜÇ
Get your tech brand or product in front of software developers.
For more information Contact us
Dirask - we help you to
solve coding problems.
Ask question.

ÔŁĄ´ŞĆ­čĺ╗ ­čÖé

Join