Pseudo Transliteration for Postgres aka `slugify`

slugify.sql

CREATE OR REPLACE FUNCTION slugify(str text) RETURNS text AS $$
    BEGIN
        RETURN regexp_replace(
           lower(translate(str,
             'äëïöüáéíóúâêîûôåãõàèìòùřšěčůńýśćłęążźĄŃÝŚĆŁĘÄËÏÖÜÁÉÍÓÚÂÊÎÛÔÅÃÕÀÈÌÒÙŘŠĚČŮŻŹß ²ø®',
             'aeiouaeiouaeiouaaoaeioursecunyscleazzANYSCLEAEIOUAEIOUAEIOUAAOAEIOURSECUZzs-2dR'
             -- missing chars will be removed
           )),
           -- strip all others chars than [^a-z0-9 \-]
           '[^a-z0-9 \-]',
           '',
           'g'
        );
    END
$$ LANGUAGE plpgsql;