Skip to content

Instantly share code, notes, and snippets.

@cazzer
Last active November 26, 2016 06:16
Show Gist options
  • Save cazzer/712bd4c8d4d3d79d44cf0e864b58fb8c to your computer and use it in GitHub Desktop.
Save cazzer/712bd4c8d4d3d79d44cf0e864b58fb8c to your computer and use it in GitHub Desktop.
Row Level Security: Trigger
create or replace function insert_user_data()
returns trigger
as $$
begin
insert into user_data (data_id, user_role) values (
new.id,
current_user
);
return new;
end
$$ language plpgsql;
create trigger insert_user_data_trigger
after insert
on data
for each row
execute procedure insert_user_data();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment