How to get a HEX DUMP of a Postgres STRING?

[David_Fergen]

How to get the HEX DUMP of a Postgres STRING datatype?

Answer:

To get the HEX DUMP the "encode" function can be used as follows:

SELECT "field1", "mystr", encode("mystr"::bytea, 'hex')
FROM "owner"."table1";

This will return the HEX DUMP of a STRING field called "mystr". Notice that we cast it as "bytea" and ask the function to return the 'hex' representation.
If you want to return it as 'base64', specify it instead of the 'hex'.