Encode dan Decode bade64 Postgresql

Beberapa sahabat pernah bertanya, bagaimana cara Encode dan Decode base64 pada PostgreSQL.

Berikut saya kasih contoh :

--DECODE

SELECT CONVERT_FROM(DECODE(prospect_name, 'base64'), 'UTF-8') FROM master_customer WHERE vcust_id='HIRTM-TEKO-312'

"SkFVSEFSSQ=="

--ENCODE

SELECT customer_id,ENCODE(CONVERT_TO(prospect_name, 'UTF-8'), 'base64') FROM master_customer ORDER BY customer_id LIMIT 10;

Semoga bermanfaat.