change number to string with lpad postgresql code example

Example: postgresql add leading zeros

SELECT lpad(42::text, 4, '0')