Supabase•11mo ago

Disable Duplicate Display Names

i was wondering if there was an easy way to disable accounts having the same display name?

garyaustin•1/30/25, 9:04 PM

Seems an odd request. Which one would be the real account to disable with the same name?

CharOP•1/30/25, 9:05 PM

somehow i types that message completely wrong...

CharOP•1/30/25, 9:06 PM

i want it so 2 users cannot have the same edisplay name

CharOP•1/30/25, 9:06 PM

garyaustin•1/30/25, 9:08 PM

You would need to come up with an insert trigger on auth.users like the user management guide uses and check and change the incoming name if it exists, unless you want to error on the signup. That would typically be done in a profile table with the name and not the auth.users name from the OAuth provider if you are using that.

I've seen that discussed here, but not sure how easy to find with search. An AI might have ideas too.

Ggaryaustin You would need to come up with an insert trigger on auth.users like the user man...

CharOP•1/30/25, 9:24 PM

is their a guide for setting something like this up?

silentworks•1/30/25, 9:25 PM

Just set the Display name column to be unique. Also don't use space in column names, only use snake_casesnake_case so it should be display_namedisplay_name.

Ssilentworks Just set the **Display name** column to be unique. Also don't use space in colum...

CharOP•1/30/25, 9:25 PM

i want stuff like user avatars as well tho

CChar i want stuff like user avatars as well tho

silentworks•1/30/25, 9:26 PM

Please don't change the goalpost as you get an answer for your previous question. Also I want stuff like user avatars as well tho has no context to it.

garyaustin•1/30/25, 9:27 PM

I think that is the authentication tab users table being shown...

garyaustin•1/30/25, 9:28 PM

That is not a public table from the OP.

Ggaryaustin I think that is the authentication tab users table being shown...

CharOP•1/30/25, 9:28 PM

it is

CChar it is

silentworks•1/30/25, 9:29 PM

Ah ok, didn't realise that. Then you should follow the https://supabase.com/docs/guides/auth/managing-user-data?queryGroups=language&language=js guide then

CharOP•1/30/25, 9:30 PM

my bad, proberbly shouldve specified more

garyaustin•1/30/25, 9:31 PM

You need to store the name in a public.profile table or the like. Then it can be marked unique, but you really need to check for duplicate, or handle the insert error, in the trigger function or it errors back to your user. If they are doing an OAuth sign in you can't control the name they are providing.

garyaustin•1/30/25, 9:33 PM

The display name you see in the UI would not change though as that is coming from OAuth if you are using that.

silentworks•1/30/25, 9:34 PM

My approach is to generally allow them to enter display name after they have registered and signed in the first time. Because as Gary stated there are two different flows depending on if you sign up with OAuth or email.

CharOP•1/30/25, 10:53 PM

i have this

import { supabase } from "../client";

export async function Auth_SignUpWithEmail({ email, password, username }: { email: string, password: string, username: string }) {
  // Sign up the user
  const { data, error } = await supabase.auth.signUp({
    email,
    password,
    options: {
      data: {
        username: username,
        picture: null,
        stores: []
      }
    }
  });


  if (error) throw new Error(error.message);

  return data
}

import { supabase } from "../client";

export async function Auth_SignUpWithEmail({ email, password, username }: { email: string, password: string, username: string }) {
  // Sign up the user
  const { data, error } = await supabase.auth.signUp({
    email,
    password,
    options: {
      data: {
        username: username,
        picture: null,
        stores: []
      }
    }
  });


  if (error) throw new Error(error.message);

  return data
}

but which works for stufgf like duplicate email, but im not sure how to check if its duplicate username

garyaustin•1/30/25, 10:53 PM

There is nothing built in. It is metadata you make up. And you say stuff like email. I believe that is the only Supabase check for duplicates as it uses email to identify a user.

garyaustin•1/30/25, 10:54 PM

You have to write your own code to handle it and really need to use the user management guide with a trigger and profile table. Then use that for user name even if you copy it in from the meta data there. See the link silentworks provided how to do the trigger and table.
Note the Supabase dashboard UI takes about 10 variations of username, first_name, last_name, etc. that OAuth providers typically use and converts that to the Display name you see in the UI.

import { supabase } from "../client"; export async function Auth_SignUpWithEmail({ email, password, username }: { email: string, password: string, username: string }) { // Sign up the user const { data, error } = await supabase.auth.signUp({ email, password, options: { data: { username: username, picture: null, stores: [] } } }); if (error) throw new Error(error.message); return data }

Disable Duplicate Display Names

Similar Threads

Similar Threads

Similar Threads