PostgreSQL trim function.

Preamble

PostgreSQL trim function removes all specified characters from the beginning or end of a line.

Syntax of trim function in PostgreSQL

trim( [ leading | trailing | both ] [ trim_character ] from string )

Parameters and function arguments

• trim_character – Remove from the front of the string.
• trailing – Remove trim_character from the end of the string.
• Both – Remove trim_character from the beginning and end of a string.
• trim_character – A set of characters to be removed from a string. If this parameter is not specified, the trim function will remove whitespace characters from the string.
• string – String to delete characters.

Note:

• If you don’t specify a value for the first parameter (leading, trailing, both), the trim function will default to both and remove trim_character from both the beginning and end of the string.
• If you don’t specify trim_character, the trim function will remove space characters by default.

The trim function 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.

Let’s look at some examples of trim functions to understand how to use trim in PostgreSQL.
For example:
(Note that for each of the examples below, we have included the result in single quotes to demonstrate that trim returns to PostgreSQL. If you run these commands yourself, you won’t see the result in single quotes).

SELECT trim(leading ' ' from ' Google.com ');

--Result: 'Google.com '

SELECT trim(trailing ' ' from ' Google.com ');

--Result: '' Google.com'

SELECT trim(both ' ' from ' Google.com ');

--Result: 'Google.com'

SELECT trim(' ' from ' Google.com ');

--Result: 'Google.com'

SELECT trim(' Google.com ');

--Result: 'Google.com'

SELECT trim(leading '0' from '000123');

--Result: '123'

SELECT trim(trailing '1' from 'Number1');

--Result: 'Number'

SELECT trim(both '123' from '123PostgreSQL123');

--Result: 'PostgreSQL'

PostgreSQL tutorial; functions

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.