文字列の文字コード表示

SELECT '0x' || 
       encode(substr(s.word::text,generate_series(1,length(s.word::text),1),1)::bytea, 'hex') AS code,
       substr(s.word::text,generate_series(1,length(s.word::text),1),1) AS char
 FROM
  (SELECT '漢字' AS word) AS s;

   code   | char 
----------+------
 0xe6bca2 | 漢
 0xe5ad97 | 字
(2 rows)

SELECT '0x'||encode(char::bytea, 'hex') AS code, char
FROM
(SELECT regexp_split_to_table('漢字', '') AS char) AS w;

こっちのが短かい。