select tgname, pg_get_triggerdef(oid)
from pg_trigger
where tgrelid = 'users'::regclass and not tgisinternal;
