update public.consultant set "role" = '台名保險經紀人' where agent_no = 'A183619275';
update public.consultant set "role" = '和泰保險經紀人' where agent_no = 'AGAM11249699';
update public.consultant set "role" = '大誠保險經紀人' where agent_no = 'Z152717443';
update public.consultant set "role" = '錠嵂保險經紀人' where agent_no = 'D265260662';
update public.consultant set "role" = '欣台保險經紀人' where agent_no = 'AG0109051204';
update public.consultant set "role" = '大誠保險經紀人' where agent_no = 'B282677963';
update public.consultant set "role" = '威盛保險經紀人' where agent_no = 'AG0101234567';
update public.consultant set "role" = '欣台保險經紀人' where agent_no = 'X147309614';
update public.consultant set "role" = '台名保險經紀人' where agent_no = 'J149388015';
update public.consultant set "role" = '錠嵂保險經紀人' where agent_no = 'R221444250';
