Base64 Decode Base64 Encode CSS Beautifier Url Encoder Url Decoder Image to Base64 Base64 to Image

PostgreSQL decode()

Decode binary data from string previously encoded with encode. Parameter type is same as in encode.

Function

decode(string text, type text)

Parameters

text - The String to be decoded
text - Decoding type

Return value

bytea - Returns the Base64 decoded version of text.

Example
select decode('YmFzZTY0IGVuY29kZWQgc3RyaW5n', 'base64');
---------------------------
base64 encoded string
Github

https://github.com/base64decode/examples/blob/master/base64decode.pgsql

See also:
PostgreSQL base64 encode