PostgreSQL lower() Function

The PostgreSQL lower() function converts the string to lowercase according to the locale rules of the database and returns it.

lower() Syntax

This is the syntax of the PostgreSQL lower() function:

lower(str)

Parameters

str

Required. A string that needs to be converted to lowercase.

Return value

The PostgreSQL lower() function returns the lowercase form of the specified string.

If the parameter is NULL, the function will return NULL.

lower() Examples

This example shows how to convert a string to lowercase using the lower() function.

SELECT lower('Hello World') AS "lower('Hello World')";

 lower('Hello World')
----------------------
 hello world