doc: PL/pgSQL to convert between bytea and urlsafe base64

[coolaj86]

PL/pgSQL function to encode bytea as urlsafe base64

CREATE OR REPLACE FUNCTION bytea_to_urlsafe_base64(bytes bytea)
RETURNS TEXT
LANGUAGE SQL
IMMUTABLE
STRICT
PARALLEL SAFE
AS $$
    SELECT replace(replace(rtrim(encode(bytes, 'base64'), '='), '+', '-'), '/', '_');
$$;

PL/pgSQL function to decode urlsafe base64 as bytea

CREATE OR REPLACE FUNCTION urlsafe_base64_to_bytea(urlbase64 TEXT)
RETURNS bytea
LANGUAGE SQL
IMMUTABLE
STRICT
PARALLEL SAFE
AS $$
    SELECT decode(
        REPLACE(REPLACE(urlbase64, '-', '+'), '_', '/') ||
        repeat('=', (4 - (length(urlbase64) % 4)) %4),
        'base64'
    );
$$;

License

The code snippets and documentation in this issue are licensed under the CC0-1.0 (Public Domain), as follows:

PostgreSQL URL-safe Base64 - convert between bytea and urlsafe base64

Authored in 2024 by AJ ONeal [email protected]
To the extent possible under law, the author(s) have dedicated all copyright
and related and neighboring rights to this software to the public domain
worldwide. This software is distributed without any warranty.

You should have received a copy of the CC0 Public Domain Dedication along with
this software. If not, see https://creativecommons.org/publicdomain/zero/1.0/