How to pull Base64 from Postgresql with minimal effort?

Question

PHP

The essence of the task is as follows: there is a Postgresql base with records in the form of base64.
The data is pulled to the site written in php. What options are there to extract this data in order to get the data in decoded form on the site?

Answer 1

You want that decoding directly at the DB level was carried out?
Then look towards https://www.postgresql.org/docs/current/static/fun...

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

Somehow, in theory

Answer 2

What is the question?
php.net/manual/en/function.base64-decode.php