Postgresql base64 encode

Question

I need to convert a db value into base64encode. I tried:

 select encode(cast(est_name as text),'base64') from establishments;

It showing error

[SQL]select encode(string(cast(est_name as text)),'base64') from establishments;

[Err] ERROR:  function string(text) does not exist
LINE 1: select encode(string(cast(est_name as text)),'base64') from ...
                      ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

Where I am wrong? please help. thanks in advance

Answer 1

Encode decode examples for string

select encode('mystring'::bytea, 'base64');
select convert_from(decode('bXlzdHJpbmc=', 'base64'), 'UTF8');

From existing column in table

select encode(mycolum::bytea, 'base64') from mytable;