Re: Find out encoding of data - Mailing list pgsql-general

joynes wrote:
> What I really want to see is the hexadecimal or octal value
> of the bytes of the retrieved data. Can postgres give me
> this somehow (without exporting tables to files and look at
> the files).

Maybe 'decode' can help you:

test=> SELECT decode('10EUR', 'escape');
     decode
----------------
 10\342\202\254
(1 row)

Yours,
Laurenz Albe