PostgreSQL 18 reference · String Functions

PostgreSQL LOWER() Function

Convert a string to lowercase using the database's locale, so letters such as É and Ü work too.

PostgreSQL 18

Create a free account to save this page, take notes and track your progress. Sign in

Syntax

lower(string)

Parameter	Description
`string`	The input text.

Lowercase text.

Lowercase a column

SELECT lower(name) AS name FROM customers WHERE customer_id <= 2;

Output

     name
--------------
 ada lovelace
 alan turing
(2 rows)

Run this on your computer — see “Get Started” for setup.

Not just ASCII

SELECT lower('ÉCOLE Ünïcode') AS result;

Output

    result
---------------
 école ünïcode
(1 row)

Run this on your computer — see “Get Started” for setup.

UPPER() · Convert a string to uppercase using the database's locale, including accented letters such as é.
INITCAP() · Capitalize the first letter of each word and lowercase the rest, as in 'ada lovelace' to 'Ada Lovelace'.
ILIKE · Match a string against a LIKE pattern ignoring case: % matches any text and _ one character. ~~* is the operator form.
SQL String Functions · tutorial