Le portail francophone de la géomatique

CREATE EXTENSION postgis;

DROP TABLE IF EXISTS cite cascade;
CREATE TABLE cite (
    nom_cite varchar(80) primary key,
    geom_cite geometry
);

insert into cite values
('Storms End', ST_GeomFromText('POINT(0.378000 0.437000)')),
('Sunspear', ST_GeomFromText('POINT(0.224000 0.473000)')),
('Braavos', ST_GeomFromText('POINT(0.682000 0.618000)')),
('Casterly Rock', ST_GeomFromText('POINT(0.507000 0.162000)')),
('Gulltown', ST_GeomFromText('POINT(0.602000 0.510000)')),
('Highgarden', ST_GeomFromText('POINT(0.365000 0.239000)'));

ERROR:  ERREUR:  n'a pas pu ouvrir le fichier de contrôle d'extension « C:/Program Files/PostgreSQL/12/share/extension/postgis.control » : No such file or directory