trigger.sql

grant usage on schema public to supabase_auth_admin;
grant all on public."Profile" to supabase_auth_admin;

create or replace function create_profile_on_user_creation() returns trigger as
$$
begin
  insert into
    public."Profile"(id, "modifiedAt")
    values(new.id, current_timestamp);

  return new;
end;
$$
language plpgsql;

create trigger create_user
  after insert on auth.users
  for each row
  execute procedure create_profile_on_user_creation();