PostgreSQL operator ||.

Preamble

PostgreSQL operator || allows combining 2 or more lines together.

Syntax for || in PostgreSQL

string1 || string2 || string_n

Operator parameters and arguments

• string1 – The first line to combine.
• string2 – The second line to merge.
• string_n – N-th line to merge.

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

PostgreSQL 11, PostgreSQL 10, PostgreSQL 9.6, PostgreSQL 9.5, PostgreSQL 9.4, PostgreSQL 9.3, PostgreSQL 9.2, PostgreSQL 9.1, PostgreSQL 9.0, PostgreSQL 8.4.

Consider the examples of concatenation to understand how to use the || operator in PostgreSQL.
For example:

SELECT 'Postgre' || 'SQL';

--Result: 'PostgreSQL'

SELECT 'Google' || '.com';

--Result: 'Google.com'

SELECT 'x' || 'y' || 'z';

--Result: "xyz"

SELECT '1' || 'a' || '2' || 'B';

--Result: '1a2B'

Learn PostgreSQL Tutorial; Full Course for Beginners

About Enteros

Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.