PostgreSQL - LOWER function

PostgreSQL - LOWER function

Last Updated : 06 Aug, 2024

In PostgreSQL, the LOWER() function is a powerful tool used to convert strings, expressions, or values in a column to lowercase. This function is essential for text normalization, making data comparisons easier and more consistent.

Let's look into the syntax, and usage of the LOWER() function in PostgreSQL with detailed examples.

What is the LOWER() Function in PostgreSQL?

The LOWER() function takes an input string and converts all the characters to lowercase. This is particularly useful when you need to perform case-insensitive comparisons or store data in a uniform format.

Syntax

LOWER(string or value or expression)

Parameter

string_or_value_or_expression: This argument can be a string, a value, or an expression that you want to convert to lowercase.

PostgreSQL LOWER function Examples

Let us take a look at some of the examples of LOWER Function in PostgreSQL to better understand the concept.

Example 1: Converting Column Values to Lowercase

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:

PostgreSQL LOWER function Example

Explanation: Here, the LOWER() function converts the title column values to lowercase.

Example 2: Converting a String to Lowercase

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

SELECT LOWER('GEEKSFORGEEKS');

Output:

PostgreSQL LOWER function Example

Explanation: The LOWER() function converts the input string 'GEEKSFORGEEKS' to 'geeksforgeeks'.

Important Points About the PostgreSQL LOWER() Function

The LOWER() function consistently converts all characters in the input to lowercase.
The function is useful for making case-insensitive comparisons.
Use the CAST function to convert non-string values to strings if necessary.
Applicable to strings, expressions, and column values.

PostgreSQL - LOWER function

R

RajuKumar19

Improve

Article Tags :

Similar Reads

PostgreSQL - NOW() Function

The NOW() function in PostgreSQL is a powerful and essential tool for retrieving the current date and time. This is particularly useful when recording actions like adding or updating records in our database. Using PostgreSQL NOW() function, we can efficiently track when events occur, making the data

PostgreSQL - LEAD Function

In PostgreSQL, the LEAD() function is a powerful window function used to access a row that follows the current row at a specific physical offset. This function is generally employed to compare the value of the current row with the value of the next row following the current row.Let us better underst

PostgreSQL - LAG Function

In PostgreSQL, the LAG() function is a powerful window function that allows you to access data from a previous row within the same result set. Itâ€™s particularly useful for comparing values in the current row with values in the preceding row, making it ideal for analytical queries in PostgreSQL.For e

PostgreSQL- LPAD Function

The LPAD() function in PostgreSQL is a powerful tool for padding a string to the left, ensuring it reaches a specified length by filling it with a designated character or characters. This function can be particularly useful in data formatting and report generation.Let us better understand the LPAD F

PostgreSQL MIN() Function

The MIN() function in PostgreSQL is an essential aggregate function that returns the minimum value in a set of values. This function is highly useful in various data analysis and reporting tasks, allowing you to quickly identify the smallest values in your datasets. Let us better understand the MIN(

PostgreSQL - MD5() Function

The PostgreSQL MD5() function is a useful tool for evaluating the MD5 hash of a given string and returning the result in hexadecimal form. This function is often used for data integrity checks and secure password storage. Let's look into the syntax, and usage of the MD5() function in PostgreSQL with

PostgreSQL - Function Overloading

In PostgreSQL, it's possible to create multiple functions with the same name, provided that each function has different arguments. This feature, known as function overloading, allows you to define functions that perform similar operations but handle different types or numbers of inputs. PostgreSQL d

PostgreSQL - NULLIF() Function

Effectively handling NULL values is important in database management, especially for ensuring data integrity and avoiding errors. PostgreSQL offers several powerful functions, such as NULLIF and COALESCE, to help manage NULL and empty values efficiently. In this article, we will guide us through the

PostgreSQL - Function Parameters

In PostgreSQL, functions provide an efficient way to encapsulate logic, perform calculations, and handle complex tasks within a database. A thorough understanding of PostgreSQL function parameters is essential for writing flexible and optimized functions.In this article, we will analyze different ty

PostgreSQL - ROW_NUMBER Function

The PostgreSQL ROW_NUMBER function is a crucial part of window functions, enabling users to assign unique sequential integers to rows within a dataset. This function is invaluable for tasks such as ranking, pagination and identifying duplicates. In this article, we will provide PostgreSQL ROW_NUMBER