PostgreSQL character_length function.

Preamble

The character_length function in PostgreSQL returns the length of the specified string.

The syntax of the character_length function in PostgreSQL

character_length( string )

Parameters and function arguments

• string – The string for which the length is returned.

The character_length function can be used in future versions of PostgreSQL

Let’s look at some examples of the character_length function to see how to use the character_length function in PostgreSQL.
For example:

SELECT character_length('Google Yandex Bing');

--Result: 18

SELECT character_length('Google.com');

--Result: 10

SELECT character_length(' Bing.com');

--Result: 9

SELECT character_length('');

--Result: 0

SELECT character_length(' ');

--Result: 1

SELECT character_length(NULL);

--Result: [null]

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