How to display blob value using x’abc’ binary string literal syntax?

select quote(uid) from blobs

returns:

X'0123456789ABCDEF0123456789ABCDEF'

and if you really need it in lowercase, you can use:

select lower(quote(uid)) from blobs