How to write a webhook of a supabase edge function?
Let's say I have an edge function called "hello-world".
How can I rewrite the SQL example from the supabase documentation to trigger the edge function "hello-world"?
create trigger "my_webhook" after insert
on "public"."my_table" for each row
execute function "supabase_functions"."http_request"(
'http://localhost:3000',
'POST',
'{"Content-Type":"application/json"}',
'{}',
'1000'
);
If the edge function must read another rls secured database table, do I have to call the edge function with a postgres role? How would I implement that in my SQL webhook?
How can I rewrite the SQL example from the supabase documentation to trigger the edge function "hello-world"?
create trigger "my_webhook" after insert
on "public"."my_table" for each row
execute function "supabase_functions"."http_request"(
'http://localhost:3000',
'POST',
'{"Content-Type":"application/json"}',
'{}',
'1000'
);
If the edge function must read another rls secured database table, do I have to call the edge function with a postgres role? How would I implement that in my SQL webhook?
