PostgreSQL lowercase and uppercase functions

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');