TO_HEX returns a VARCHAR representing the hexadecimal equivalent of a number.
Syntax
TO_HEX ( number )
Semantics
number
(INTEGER) is the number to convert to hexadecimal
Examples
=> SELECT TO_HEX(123456789);
to_hex
---------
75bcd15
(1 row)