Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

PostgreSQL- LOWER function

  • Last Updated : 08 Oct, 2021

In PostgreSQL, the LOWER function is used to convert a string, an expression, or values in a column to lower case.

Syntax: LOWER(string or value or expression)

Let’s analyze the above syntax:

  • The LOWER function takes in value with either all uppercase or partial uppercase values or characters and convert them into lower case of the same type.
  • If the supplied argument is string-convertible, one can make use of the CAST function which converts a non-string value to a string.

Example 1:

The below statement uses LOWER function to get the full names of the films from the Film table of the sample database, ie, dvdrental:

SELECT LOWER(title) from film;

Output:

Example 2:

The below statement converts an upper case string to lower case:

SELECT LOWER('GEEKSFORGEEKS');

Output:

My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!