Convert from hex to string - Mailing list pgsql-general

From Yuriy Rusinov
Subject Convert from hex to string
Date
Msg-id CAA5U4syE1YdKFaWCv=95D3v9Zyz=T8yitQp3MaaC8smDMTD-Mw@mail.gmail.com
Whole thread Raw
Responses Re: Convert from hex to string  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Convert from hex to string  (Francisco Olarte <folarte@peoplecall.com>)
List pgsql-general
Hello, Colleagues !

I have to transform string, encoded to hexadecimal to text, but if I try to
select encode('Qt is great!', 'hex'); I receive valid and correct results

517420697320677265617421

but if I try to select decode ('517420697320677265617421', 'hex'), I
receive the same string, such as
'\x517420697320677265617421, which way I have to do for valid convert
to/from hexadecimal ?

Thanks for attention.
--
Best regards,
Sincerely yours,
Yuriy Rusinov.


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Unexpected behaviour of 'DEFERRABLE INITIALLY DEFERRED'
Next
From: Adrian Klaver
Date:
Subject: Re: Convert from hex to string