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

Clodoaldo Neto · Accepted Answer · 2014-05-16 15:30:58Z

24

The encode function encodes from bytea to text.

select encode(est_name::bytea, 'base64') 
from establishments;

http://www.postgresql.org/docs/current/static/functions-binarystring.html#FUNCTIONS-BINARYSTRING-OTHER

answered May 16, 2014 at 15:30

Clodoaldo Neto

127k30 gold badges251 silver badges274 bronze badges

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

6 Comments

Pradeep.T.P Over a year ago

It showing error: [SQL]select encode(est_name::bytea, 'base64') from establishments; [Err] ERROR: invalid input syntax for type bytea The actual field type is character_varying(250)

Clodoaldo Neto Over a year ago

@Pradeep What is the type of est_name? Show sample data

Pradeep.T.P Over a year ago

The field is varchar (250) and sample data below : Gift Express, Mozart Musical Instruments, Ralph Lauren, Toscana, Damas, Atrium Cafe, Tanagra etc

Clodoaldo Neto Over a year ago

@Pradeep Works for me. Is the etc the end of the data or it means there is more? Add a few lines of the data to the question.

Pradeep.T.P Over a year ago

I am using 9.2 version

|

Jeremy Busk · Accepted Answer · 2021-09-19 23:15:22Z

14

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;

answered Sep 19, 2021 at 23:15

Jeremy Busk

5035 silver badges5 bronze badges

Collectives™ on Stack Overflow

Postgresql base64 encode

2 Answers 2

6 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related