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)
- On this page
- Parameters
- Examples