Vol. I · A Postgres Handbook

The Query & the Schema

A reading-room reference for writing PostgreSQL by hand — selects to window functions, with the schema in plain view.

EasyString Functions

UPPER, LOWER, INITCAP: case functions

The query

SQL
SELECT
  UPPER(first_name) AS upper_name,
  LOWER(last_name) AS lower_name,
  INITCAP(LOWER(first_name || ' ' || last_name)) AS proper_name
FROM employees;
Tested against PostgreSQL 16

Note

“INITCAP capitalizes first letter of each word. PostgreSQL-specific (not in standard SQL).

Tables referenced