postgresqlHow do I convert a string to lowercase in PostgreSQL?
To convert a string to lowercase in PostgreSQL, you can use the LOWER
function. This function takes a string as its argument and returns the same string in all lowercase letters.
For example, the following code block:
SELECT LOWER('STRING');
will return the following output:
string
The LOWER
function can be used in a variety of contexts, such as in a SELECT
clause, in a WHERE
clause, and in a GROUP BY
clause.
The syntax for the LOWER
function is as follows:
LOWER(string)
Where string
is the string to be converted to lowercase.
Here are some useful links for more information on the LOWER
function:
More of Postgresql
- How do I parse XML data using PostgreSQL?
- How do I use PostgreSQL ZonedDateTime to store date and time information?
- How can I set a PostgreSQL interval to zero?
- How can Zalando use PostgreSQL to improve its software development?
- How can I troubleshoot zero damaged pages in PostgreSQL?
- How can I use PostgreSQL with Zabbix?
- How can I monitor PostgreSQL performance using Zabbix?
- How can I integrate PostgreSQL with Yii2?
- How can I use PostgreSQL with YAML?
- How can I use PostgreSQL XML functions to manipulate XML data?
See more codes...