Error in decode and convert_from in Postgres

6

Has anyone had the problem of Postgres giving base64 decode error? I have the following call that says [Err] ERROR: End of sequence is invalid

convert_from(decode('YnJhc2lsc2VtbGVp', 'base64'), 'UTF8')

Remembering that where I have 'YnJhc2lsc2VtbGVp' I'm using a variable, so stay that way

convert_from(decode(variavel, 'base64'), 'UTF8')
    
asked by anonymous 27.11.2014 / 15:37

1 answer

0

Situation resolved.

I made a conversion from the field to type TEXT and resolved.

    
27.11.2014 / 16:34