PostgreSQL LTRIM function.

Preamble

The PostgreSQL LTRIM function removes all specified characters on the left side of the line.

Syntax of LTRIM function in PostgreSQL

ltrim( string, trim_character )

Parameters and function arguments

• string – String for trimming on the left side.
• trim_character – A set of characters to be removed from the left side of the string. If this option is skipped, the ltrim function will remove spaces on the left side of the string.

The ltrim function can be used in the following PostgreSQL versions

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 some examples of ltrim functions to understand how to use the ltrim function in PostgreSQL.
For example:
(Note that for each of the examples below, we have included the result in single quotes to demonstrate what ltrim returns to PostgreSQL. If you run these commands yourself, you won’t see single quotes in the result).

SELECT ltrim(' Google.com ', ' ');

--Result: 'Google.com '

SELECT ltrim(' Google Amazon Bing ');

--Result: 'Google Amazon Bing '

SELECT ltrim(' Google.com');

--Result: 'Google.com'

SELECT ltrim('000123', '0');

--Result: '123'

Tutorial; Creating Functions in PostgreSQL

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.​