PostgreSQL length function.

Preamble

PostgreSQL length function returns the length of the specified string, expressed in the number of characters.

Syntax of the length function in PostgreSQL

length( string )

Parameters and function arguments

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

The length 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.

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

SELECT length('Google Yandex Bing');

--Result: 18

SELECT length('Google.com');

--Result: 10

SELECT length(' Yandex.com');

--Result: 11

SELECT length('');

--Result: 0

SELECT length(' ');

--Result: 1

SELECT length(NULL);

--Result: [null];

Use PostgreSQL Constraints, Functions and Triggers for Data Validations

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.