PostgreSQL: lower Function

This PostgreSQL tutorial explains how to use the PostgreSQL lower function with syntax and examples.

Description

The PostgreSQL lower function converts all characters in the specified string to lowercase.

Syntax

The syntax for the lower function in PostgreSQL is:

lower( string )

Parameters or Arguments

string

The string to convert to lowercase.

Note

• If there are characters in the string that are not letters, they are unaffected by the lower function.
• See also the upper function.

Applies To

The lower 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 lower function examples and explore how to use the lower function in PostgreSQL.

For example:

postgres=# SELECT lower('Tech on the Net');
      lower
-----------------
tech on the net
(1 row)

postgres=# SELECT lower('TechOnTheNet.com is #1');
         lower
------------------------
 techonthenet.com is #1
(1 row)