PostgreSQL replace function.

Preamble

The PostgreSQL replace function replaces all occurrences of the specified string.

Syntax of the replace function in PostgreSQL

replace( string, from_substring, to_substring )

Parameters and arguments

• string – Source line.
• from_substring – A search substring. All entries from_substring found in the string are replaced by to_substring.
• to_substring – Replacement of substring. All occurrences from_substring found in the string are replaced by to_substring.

Note:

• The replace function performs case sensitive replacement.

The replace function can be used in future 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.

Let’s look at some examples of replace functions to understand how to use the replace function in PostgreSQL.
For example:

SELECT replace('Google.com', 'Google', 'Bing');

--Result: Bing.com

SELECT replace('Google.com', 'google', 'bing');

--Result: Google.com

SELECT replace('abc abc', 'a', 'B');

--Result: Bbc Bbc

SELECT replace('abc abc', 'A', 'B');

--Result: abc abc

SQL String Functions Tutorial (LEFT, RIGHT, POSITION, CONCAT, LOWER, REPLACE)

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.