Hey Folks! Is it possible to add new columns to th...
# helpj
jak
10/02/2021, 9:42 AMHey Folks! Is it possible to add new columns to the auth user table in supabase? Ideally, i'd like to add a column for the users role.
b
bnjmnt4n
10/02/2021, 10:20 AMIt's not recommended to directly alter the auth.users table since it might change as supabase changes their system
bnjmnt4n
10/02/2021, 10:21 AMThe recommended approach is to create a new users table to store your own additions, with a foreign key reference to
auth.usersj
jak
10/02/2021, 11:34 AMThanks for that @User . So whilst it is possible to edit the auth.users table, it might lead to problems later. I'll follow your advice 🙂
b
Bonathan
10/03/2021, 10:14 AMHey, I am unsure how or where to reference auth.users. Would that then reference the entire auth.users table?