PostgreSQL concat() Function

The PostgreSQL concat() function concatenates all arguments as a string and returns the result.

concat() Syntax

This is the syntax of the PostgreSQL concat() function:

concat(param1[, param2] ...)

Parameters

param1

Required. A value of any data type.

param2...

Optional. A value of any data type.

Return value

The PostgreSQL concat() function concatenates all arguments as a string and returns the result. The NULL parameter will be skipped.

concat() Examples

This example shows how to concatenate multiple arguments as a string using the concat() function.

SELECT concat('Hello', 'World') AS "concat('Hello', 'World')";

 concat('Hello', 'World')
--------------------------
 HelloWorld