PostgreSQL: character_length Function

In this PostgreSQL post explains how to use the PostgreSQL character_length function with syntax and examples.

Description

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

Syntax

The syntax for the character_length function in PostgreSQL is:

character_length( string )

Parameters or Arguments

string

The string to return the length for.

Note

• See also the char_length and length functions.

Applies To

The character_length function can be used in the following versions of PostgreSQL:

• PostgreSQL 9.4, PostgreSQL 9.3, PostgreSQL 9.2, PostgreSQL 9.1, PostgreSQL 9.0, PostgreSQL 8.4

Example

Let's look at some PostgreSQL character_length function examples and explore how to use the character_length function in PostgreSQL.

For example:

postgres=# SELECT character_length('AODBA.com');
 character_length
------------------

               16
(1 row)

postgres=# SELECT character_length('');
 character_length
------------------

               0
(1 row)

postgres=# SELECT character_length(' ');
 character_length
------------------

               1
(1 row)

postgres=# SELECT character_length(NULL);
 character_length
------------------

            NULL>
(1 row)