upper()

A system function for converting a string to upper case

upper() is a system function for converting a string to upper case, in accordance with the database's locale setting.<

upper() was added in PostgreSQL 6.1.

Usage

upper ( text ) → text

Basic usage of upper():

postgres=# SELECT upper('foo BAR Baz');
    upper
-------------
 FOO BAR BAZ
(1 row)

Locale-specific upper casing:

tr_test=# SHOW lc_collate;
 lc_collate
------------
 tr_TR.utf8
(1 row)

tr_test=# SELECT upper('ıi');
 upper
-------
 Iİ
(1 row)

upper() is ineffective in scripts where there is no concept of case:

postgres=# SELECT upper('ほげホゲ');
  upper
----------
 ほげホゲ
(1 row)