-- DROP VIEW vu_sites_spe_typo;

CREATE OR REPLACE VIEW vu_sites_spe_typo AS 
 SELECT sites_spe.id_site_spe, sites_spe.intitule, sites_spe.ref_typ_spe, lst_site_spe_typo.type_site
   FROM sites_spe
   JOIN lst_site_spe_typo ON sites_spe.ref_typ_spe = lst_site_spe_typo.id_site_spe_typ;

ALTER TABLE vu_sites_spe_typo OWNER TO postgres;