collision resistance prefixed ID for PostgreSQL

pgSqlPrefixedId.sql

-- This requires nanoid to be installed to work
-- https://github.com/viascom/nanoid-postgres

CREATE EXTENSION IF NOT EXISTS pgcrypto;

CREATE OR REPLACE FUNCTION prefixedid(
    prefix text,
    size int DEFAULT 24,
    alphabet text DEFAULT '0123456789abcdefghijklmnopqrstuvwxyz'
)
    RETURNS text
    LANGUAGE plpgsql
    volatile
AS
$$
DECLARE
    idBuilder      text := '';
BEGIN
    idBuilder := idBuilder || prefix || '_' || nanoid(size,alphabet);
    return idBuilder;
END
$$;