Product Documentation

Appearance

All platforms

LENGTH ​

Return the length of a character string, in terms of the number of characters. (The CHAR_LENGTH function also returns the number of characters.)

LENGTH(string)
premdb=# SELECT LENGTH(nickname), CHAR_LENGTH(nickname) FROM team WHERE city='London';
 length | char_length 
--------+-------------
     7 |           7
     7 |           7
    10 |          10
     6 |           6
     9 |           9
     5 |           5
     5 |           5
     7 |           7
     4 |           4
(9 rows)