totn PostgreSQL Functions

PostgreSQL: character_length Function

This PostgreSQL tutorial 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

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('Tech on the Net');
 character_length
------------------
               15
(1 row)

postgres=# SELECT character_length('techonthenet.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)
Share on: