LOWER

Returns a VARCHAR value containing the argument converted to lowercase letters.

LOWER treats the string argument as a UTF-8 encoded string, rather than depending on the collation setting of the locale (for example, collation=binary) to identify the encoding.

Behavior Type

stable

Syntax

LOWER ( expression )

Parameters

expression

CHAR or VARCHAR string to convert

Notes

LOWER is restricted to 32500 octet inputs, since it is possible for the UTF-8 representation of result to double in size.

Examples

=> SELECT LOWER('AbCdEfG');
  LOWER
---------
 abcdefg
(1 row)
=> SELECT LOWER('The Bat In The Hat');
       LOWER
--------------------
 the bat in the hat
(1 row)
=> SELECT LOWER('ÉTUDIANT');
  LOWER
----------
 étudiant
(1 row)