bytea
根据这个答案,我发现了我的解决方案。
SELECT encode(my_column::bytea, 'hex') FROM my_table;
select ... encode(k1.keyword, 'hex')
ERROR: function encode(character varying, unknown) does not exist
select ... encode(k1.keyword, 'hex')
:ERROR: function encode(character varying, unknown) does not exist
- ChloeSELECT encode(my_column::bytea, 'hex') FROM my_table;
- acj