PostgreSQL: || Operator

This PostgreSQL tutorial explains how to use the PostgreSQL || concatenate operator with syntax and examples.

Description

The PostgreSQL || operator allows you to concatenate 2 or more strings together.

Syntax

The syntax for the || operator in PostgreSQL is:

string1 || string2 || string_n

Parameters or Arguments

string1

The first string to concatenate.

string2

The second string to concatenate.

string_n

The nth string to concatenate.

Applies To

The || operator can be used in the following versions of PostgreSQL:

• PostgreSQL 9.4, PostgreSQL 9.3, PostgreSQL 9.2, PostgreSQL 9.1, PostgreSQL 9.0, PostgreSQL 8.4

Example

Let's look at some concatenation examples and explore how to use the || operator in PostgreSQL.

For example:

postgres=# SELECT 'Tech on' || ' the Net' AS result;
     result
------------------
 Tech on the Net
(1 row)

postgres=# SELECT 'TechOnTheNet' || '.com' AS result;
     result
------------------
 TechOnTheNet.com
(1 row)

postgres=# SELECT 'a' || 'b' || 'c' || 'd' AS result;
 result
--------
 abcd
(1 row)