How to use Select query in encode decode function postgresql

Question

I have checked on web I got one example like

select convert_from(decode(encode('abc', 'base64'), 'base64'), 'UTF8');

now I want to decode my string so I am trying the same with below mentioned

select convert_from(decode(encode((select resumestring from submitapplications where id=1030), 'base64'), 'base64'), 'UTF8');

ERROR:  function encode(text, unknown) does not exist

LINE 1: select convert_from(decode(encode((select resumestring from ...

Do you want actually decode or encode? What kind of data does your table contain? Add the table definition and some sample data to the question — Tom-db
– Tom-db, Commented Feb 17, 2016 at 10:51

Osoian Marcel · Accepted Answer · 2016-02-17 10:56:57Z

3

SELECT
    convert_from(
        decode(
            encode(
                convert_to(
                    (
                        select resumestring from submitapplications where id=1030
                    ),
                    'UTF-8'
                ),
                'base64'
            ),
            'base64'
        ),
        'UTF8'
    )

answered Feb 17, 2016 at 10:56

Osoian Marcel

3793 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to use Select query in encode decode function postgresql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related