LOWER
Converts all letters of a string to lower case.
PostgreSQL 17.9
LOWER(string)- string
- Source stringtext
Return value
A string in lower case by the rules of the database locale, including Cyrillic
Examples
String in lowercase
PostgreSQL 17.9
SELECT LOWER('Привет, PostgreSQL');Names in lowercase
PostgreSQL 17.9
SELECT member_name,
LOWER(member_name) AS lower_name
FROM FamilyMembers;Details
To compare strings ignoring case, convert both sides to the same case: WHERE LOWER(member_name) = LOWER('Andie QUINCEY'). For case-insensitive pattern matching there is the ILIKE operator.