PostgreSQL - UPPER Function Last Updated : 15 Jul, 2025 Comments Improve Suggest changes Like Article Like Report 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.SyntaxUPPER(string_expression)How Does the UPPER Function Work?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.PostgreSQL UPPER Function ExamplesLet us look at some of the examples of UPPER Function in PostgreSQL to better understand the concept.Example 1: Combining UPPER with CONCATThe 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.Example 2: Converting a String to Upper CaseThe 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'.Important Points About PostgreSQL UPPER FunctionThe 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. Comment More infoAdvertise with us Next Article PostgreSQL - TRIM Function R rajukumar19 Follow Improve Article Tags : PostgreSQL PostgreSQL-function PostgreSQL-String-function Similar Reads PostgreSQL - TRIM Function The TRIM() function in PostgreSQL is an essential tool for removing unwanted characters from strings. Whether we're working with user inputs, formatting text, or performing data cleansing operations, TRIM() is an invaluable function for managing string data. This article will provide an in-depth loo 4 min read PostgreSQL - TRIM Function The TRIM() function in PostgreSQL is an essential tool for removing unwanted characters from strings. Whether we're working with user inputs, formatting text, or performing data cleansing operations, TRIM() is an invaluable function for managing string data. This article will provide an in-depth loo 4 min read PostgreSQL REVERSE() Function The REVERSE() function in PostgreSQL is a simple yet powerful tool used to reverse the order of characters in a given string. It takes one input which is a string and returns the characters in reverse order. This function is helpful when you need to transform data, run tests or validate information. 4 min read PostgreSQL - RIGHT Function The PostgreSQL RIGHT() function, allows you to extract a specified number of characters from the right side of a string. This function can be incredibly useful for various text-processing tasks.Let us get a better understanding of the RIGHT Function in PostgreSQL from this article.SyntaxRIGHT(string 2 min read PostgreSQL - RIGHT Function The PostgreSQL RIGHT() function, allows you to extract a specified number of characters from the right side of a string. This function can be incredibly useful for various text-processing tasks.Let us get a better understanding of the RIGHT Function in PostgreSQL from this article.SyntaxRIGHT(string 2 min read PostgreSQL String Functions PostgreSQL is a powerful, open-source relational database management system that offers a rich set of functions and operators for working with string data. String manipulation is an essential task in many applications, and PostgreSQL provides a variety of built-in functions to make working with text 8 min read Like