to_base64()

Converts a blob to a base64 encoded string.

Arguments & returns

Scalar

Overload link	`blob`	Returns
#01	`BLOB`	`VARCHAR`

SELECT to_base64('A'::BLOB);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT
  base64('A'::BLOB);

SELECT BASE64_ENCODE(x)

In DuckDB

SELECT TO_BASE64(x)