postgresql format number as text with leading zeros code example Example: postgresql add leading zeros SELECT lpad(42::text, 4, '0')