dbsd_sql.sql

create table if not exists audit(
	id serial,
	hi varchar
	);

create table if not exists trigger_tbl(
	id serial,
	log_text varchar
);



insert into audit(hi) values ('hi');
-- 
drop trigger holiday_trigger on audit;
drop function if exists checkday();
create or replace function checkday()
returns trigger as	
$$
begin
	if (select extract(dow from current_date)) in (6,0) then
		raise exception 'it is holiday';
	end if;	
	return new;
end;
$$ language plpgsql;

create TRIGGER holiday_trigger before insert or Delete or update on audit
for each row execute procedure checkday();