Functions for Data Encoding #

All encoding functions are located in the public schema, which is default.

string encode(string, encoding) #

Encode the string using the specified encoding.

Supported encodings are:

• base64
• base64url

select {"data": [1,2,3]}::string::encode("base64");
["eyJkYXRhIjogWzEsIDIsIDNdfQ=="]

string decode(string, encoding) #

Decode the string using the specified encoding.

Supported encodings are:

• base64
• base64url

select "eyJkYXRhIjogWzEsIDIsIDNdfQ=="::decode("base64")::json_import;
[{
  "data": [1, 2, 3]
}]