Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://www.geeksforgeeks.org/postgresql/postgresql-upper-function/ below:

PostgreSQL - UPPER Function - GeeksforGeeks

Last Updated : 15 Jul, 2025

In PostgreSQL, the UPPER function is utilized to convert a string into uppercase. This function is handy when you need to standardize text data by converting it to a uniform case, especially for comparison or display purposes.

Let us get a better understanding of the UPPER Function in PostgreSQL from this article.

UPPER(string_expression)

Like the LOWER function, the UPPER function accepts a string expression or string-convertible expression and converts it to an upper case format. In case the argument is not a string, the user must use the CAST function to explicitly convert it.

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

The following statement uses the CONCAT function and UPPER function to return the full name of staff in the upper case from the staff table.

Query:

SELECT
    CONCAT (
        UPPER (first_name),
        UPPER (last_name)
    ) AS full_name
FROM
    staff;

Output:

Explanation:

• 'UPPER(first_name)' converts the 'first_name' column to uppercase.
• 'UPPER(last_name)' converts the 'last_name' column to uppercase.
• CONCAT concatenates the uppercase first name and last name with a space in between, resulting in a full name in uppercase.

The following statement converts a lower case string to an upper case format.

Query:

SELECT UPPER('geeksforgeeks');

Output:

Explanation: 'UPPER('geeksforgeeks')' converts the string 'geeksforgeeks' to uppercase, resulting in 'GEEKSFORGEEKS'.

• The UPPER function converts all characters in the string to uppercase. This is useful for standardizing text data.
• To perform case-insensitive searches, convert both the column and the search term to uppercase.
• If the argument is not a string, you need to use the CAST function to convert it explicitly to a string.
• Standardizing case with UPPER before making comparisons can help avoid issues related to case sensitivity.

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4