DROP TRIGGER IF EXISTS trg_jobs_search_vector ON jobs; CREATE TRIGGER trg_jobs_search_vector BEFORE INSERT OR UPDATE OF title, company_name, location, description ON jobs FOR EACH ROW EXECUTE FUNCTION jobs_search_vector_update();
DROP TRIGGER IF EXISTS trg_kenyan_jobs_search_vector ON kenyan_jobs; CREATE TRIGGER trg_kenyan_jobs_search_vector BEFORE INSERT OR UPDATE OF title, company_name, location, description ON kenyan_jobs FOR EACH ROW EXECUTE FUNCTION kenyan_jobs_search_vector_update();
SELECT tgname AS trigger_name, tgrelid::regclass AS table_name, pg_get_triggerdef(oid) AS definition FROM pg_trigger WHERE tgname IN ('trg_jobs_search_vector', 'trg_kenyan_jobs_search_vector') AND NOT tgisinternal;
