# PostgreSQL lowercase and uppercase functions

**URL:** <https://linux-tips.com/t/postgresql-lowercase-and-uppercase-functions/244>\
**Category:** Database\
**Created:** [January 17, 2015, 4:21pm UTC](https://linux-tips.com/t/postgresql-lowercase-and-uppercase-functions/244 "2015-01-17T16:21:08Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Debuser](https://linux-tips.com/letter_avatar_proxy/v4/letter/d/96bed5/32.png) [@Debuser](https://linux-tips.com/u/Debuser)\
**Post date:** [January 17, 2015, 4:21pm UTC](https://linux-tips.com/t/postgresql-lowercase-and-uppercase-functions/244/1 "2015-01-17T16:21:08Z")

</div>

To convert strings to lowercase in PostgreSQL you can use **LOWER** function like this:

```
> SELECT LOWER(lastname) FROM users;
> SELECT LOWER('Test');

```

You can use **UPPER** function for uppercase convertion like this:

```
> SELECT UPPER(lastname) FROM users;
> SELECT UPPER('Test');
```