sql snippets used for supabase

create-new-user-trigger.sql

-- inserts a row into public.users
create function public.handle_new_user() 
returns trigger as $$
begin
  insert into public.users (id)
  values (new.id);
  return new;
end;
$$ language plpgsql security definer;

-- trigger the function every time a user is created
create trigger on_auth_user_created
  after insert on auth.users
  for each row execute procedure public.handle_new_user();

create-table.sql

create table users (
  id uuid references auth.users not null primary key,
  email text
);