Blob Functions
Version dev
Version:
FunctionDescriptionExampleResultAliases

decode(blob)

Convert blob to varchar. Fails if blob is not valid utf-8

decode('\xC3\xBC'::BLOB)

ü

encode(string)

Convert varchar to blob. Converts utf-8 characters into literal encoding

encode('my_string_with_ü')

my_string_with_\xC3\xBC

from_base64(string)

Convert a base64 encoded string to a character string

from_base64('QQ==')

A

to_base64(blob)

Convert a blob to a base64 encoded string

base64('A'::blob)

QQ==

base64

Search Shortcut cmd + k | ctrl + k