Β© 2026 Hedgehog Software, LLC
const handleSignUp = async () => { const { data:datas, error:errors } = await supabase .from('profiles') .select() .eq('userName', user_name) if (datas.length != 0) {setWarning("Username already being used"); return} if (user_name == '' || email == '' || password == ''){ setWarning("No empty usernames, email, or passwords"); return} const res = await supabase.auth.signUp({ email, password, options: { data: {user_name: user_name}, emailRedirectTo: `${location.origin}/auth/callback` } }) setUser(res.data.user); router.refresh(); setEmail(''); setPassword(''); }
BEGIN INSERT INTO public.profiles (id, userName, avatar_url) VALUES (NEW.id, NEW.raw_user_meta_data ->> 'user_name', 'https://i.imgur.com/Rg4oOtW.png'); RETURN NEW; END;
create trigger create_profile_for_new_user after insert on auth.users for each row execute function create_profile_for_new_user();