8 lines
254 B
PL/PgSQL
8 lines
254 B
PL/PgSQL
CREATE OR REPLACE FUNCTION madbase_realtime.broadcast_changes() RETURNS trigger AS $$
|
|
BEGIN
|
|
RAISE WARNING 'Trigger Fired by %', current_user;
|
|
PERFORM pg_notify('madbase_realtime', '{"test": "trigger"}');
|
|
RETURN NEW;
|
|
END;
|
|
$$ LANGUAGE plpgsql;
|