Working with text

Reshape text

Postgres has a deep string toolkit. The everyday ones:

• upper(s) / lower(s) — change case
• length(s) — number of characters
• s1 || s2 — concatenate ('a' || 'b' → 'ab')
• trim(s), substring(s FROM 1 FOR 3), replace(s, a, b)
• split_part(s, delim, n) — the nth piece after splitting

SELECT name || ' (' || city || ')' AS label FROM customers;