triggers.sql

CREATE OR REPLACE FUNCTION user_schema_creator() 
RETURNS trigger LANGUAGE plpgsql
AS
$$
begin 
	EXECUTE 'CREATE SCHEMA user_'||new.id||' AUTHORIZATION postgres';
	return new;
end;
$$
CREATE OR REPLACE FUNCTION user_schema_delete() 
RETURNS trigger LANGUAGE plpgsql
AS
$$
begin 
	EXECUTE 'DROP SCHEMA user_'||old.id||' cascade';
	return new;
end;
$$
create trigger usuarios_schema after insert
on usuario for each row
EXECUTE PROCEDURE user_schema_creator();

create trigger usuarios_delete_schema after delete
on usuario for each row
execute procedure user_schema_delete();