gistfile1.txt

CREATE OR REPLACE FUNCTION "public"."create_profile_on_signup"() RETURNS "trigger"
    LANGUAGE "plpgsql" SECURITY DEFINER
    AS $$begin
  INSERT INTO public.profile (id)
  VALUES (
    NEW.id
  );
  RETURN NEW;
end;$$;

create trigger create_profile_on_signup after insert on auth.users for each row execute function create_profile_on_signup();