1
edit
Changes
→PostgreSQL Specifications
INSERT INTO mytable (testcol)
VALUES (decode('013d7d16d7ad4fefb61bd95b765c8ceb', 'hex'))
SELECT ENCODE(testcol, 'hex') FROM mytable; // prints: 013d7d16d7ad4fefb61bd95b765c8ceb
SELECT testcol FROM mytable; // prints: \x013d7d16d7ad4fefb61bd95b765c8ceb
</source>