BASE64_DECODE v14

Use the BASE64_DECODE function to translate a Base64 encoded string to the original value originally encoded by BASE64_ENCODE. The signature is:

BASE64_DECODE (<r> IN RAW)

This function returns a RAW value.

Parameters

r

r is the string that contains the Base64 encoded data to translate to RAW form.

Examples

Before executing the following example, invoke the command:

SET bytea_output = escape;

This command instructs the server to escape any non-printable characters and to display BYTEA or RAW values onscreen in readable form. For more information, see the Postgres core documentation.

This example encodes a string that contains the text abc using BASE64_ENCODE and then decodes the string using BASE64_DECODE:

edb=# SELECT UTL_ENCODE.BASE64_ENCODE(CAST ('abc' AS RAW));
 base64_encode
---------------
 YWJj
(1 row)

edb=# SELECT UTL_ENCODE.BASE64_DECODE(CAST ('YWJj' AS RAW));
 base64_decode
---------------
 abc
(1 row)