CREATE OR REPLACE FUNCTION trigger_update_token_metadata()
RETURNS TRIGGER AS $$
BEGIN
PERFORM net.http_post(
url := 'http://api:8000/functions/v1/update-token-metadata',
body := jsonb_build_object('record', to_jsonb(NEW)),
headers := '{"Content-Type": "application/json"}'::jsonb
);
RETURN NEW;
END;
$$ LANGUAGE plpgsql SECURITY DEFINER;
CREATE TRIGGER update_token_metadata_trigger
AFTER INSERT ON tokens
FOR EACH ROW
EXECUTE FUNCTION trigger_update_token_metadata();
CREATE OR REPLACE FUNCTION trigger_update_token_metadata()
RETURNS TRIGGER AS $$
BEGIN
PERFORM net.http_post(
url := 'http://api:8000/functions/v1/update-token-metadata',
body := jsonb_build_object('record', to_jsonb(NEW)),
headers := '{"Content-Type": "application/json"}'::jsonb
);
RETURN NEW;
END;
$$ LANGUAGE plpgsql SECURITY DEFINER;
CREATE TRIGGER update_token_metadata_trigger
AFTER INSERT ON tokens
FOR EACH ROW
EXECUTE FUNCTION trigger_update_token_metadata();