PostgreSQL: remove all Bucardo triggers from a schema

1 2 3 4 5 6 7 8 9 10 11 12 13

do $$ declare     _row record;     _query text; begin     for _row in SELECT tgname, tgrelid::regclass as table_name FROM pg_trigger where tgname ~ 'bucardo' and tgrelid::regclass::text ~ 'shared_db' loop         _query := format('drop trigger %s on %s', _row.tgname, _row.table_name);         raise notice '%', _query;         execute _query;     end loop; end $$;