How to pull from Postgresql Base64 minimum effort?

The essence of the problem is this: Postgresql database with records in the form of base64.
The data could be extracted to a website written in php. What are the options to pull this data to get to the site data in decoded form?
July 4th 19 at 23:43
2 answers
July 4th 19 at 23:45
You want to decode directly on the DB level was carried out ?
Then look in the direction of https://www.postgresql.org/docs/current/static/fun...

select encode(data::bytea, 'base64') 
from table;

Somehow, the idea
July 4th 19 at 23:47

Find more questions by tags PHPPostgreSQL