UPDATE spatial.sites_pt
SET nom_site = public.sites.libl_site
FROM public.sites 
WHERE sites.code_site = sites_pt.codesite;
