Search Shortcut cmd + k | ctrl + k
0.10 (stable)
Blob Functions
FunctionDescriptionExampleResultAliases

create_sort_key(parameters...)

Constructs a binary-comparable sort key based on a set of input parameters and sort qualifiers

create_sort_key('A', 'DESC')

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

About this page

Last modified: 2024-03-02