slugify.sql

create extension if not exists "unaccent";

create or replace function slugify(name text)
    returns text as $$

begin
    return trim(
        regexp_replace(
            unaccent(lower(name)),
            '[^0-9a-z]+',
            '-',
            'g' 
        ),  
        '-' 
    );  
end; $$
language plpgsql;