Pseudo Transliteration for Postgres aka `slugify`

slugify.sql

CREATE OR REPLACE FUNCTION slugify(str text) RETURNS text AS $$
BEGIN
  RETURN lower(translate(str, 
    'äëïöüáéíóúâêîûôåãõàèìòùřšěčůńýśćłęąĄŃÝŚĆŁĘÄËÏÖÜÁÉÍÓÚÂÊÎÛÔÅÃÕÀÈÌÒÙŘŠĚČŮß :;-²ø®(),./\"’`''',
    'aeiouaeiouaeiouaaoaeioursecunyscleaANYSCLEAEIOUAEIOUAEIOUAAOAEIOURSECUs____2dR' -- missing chars will be removed
  ));
END
$$ LANGUAGE plpgsql;

Thanks for sharing, I've updated Your gist by adding regexp_replace that strips all other chars than [0-9A-Za-z -]. You can see it here:
https://gist.github.com/lechup/a69d1ee6116a39a7b12ca85efd5febf7