PostgreSQL char_length function.

Preamble

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

Syntax of char_length function in PostgreSQL

char_length( string )

Parameters and function arguments

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

The char_length 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 the char_length function to see how to use the char_length function in PostgreSQL.
For example:

SELECT char_length('Google Yandex Bing');

--Result: 18

SELECT char_length('Google.com');

--Result: 10

SELECT char_length(' Bing.com');

--Result: 9

SELECT char_length('');

--Result: 0

SELECT char_length(' ');

--Result: 1

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