PostGis

 CREATE EXTENSION postgis WITH SCHEMA public;

ALTER DATABASE test SET search_path TO public, postgis;

SELECT PostGIS_Full_Version();

DROP EXTENSION IF exists postgis;

CREATE EXTENSION postgis WITH SCHEMA public;

DROP EXTENSION IF exists "uuid-ossp";

CREATE EXTENSION "uuid-ossp" WITH SCHEMA public;

DROP EXTENSION IF exists unaccent;

CREATE EXTENSION unaccent WITH SCHEMA public;

DROP EXTENSION IF exists cube;

CREATE EXTENSION cube WITH SCHEMA public;

DROP EXTENSION IF exists ltree;

CREATE EXTENSION ltree WITH SCHEMA public;

DROP EXTENSION IF exists tablefunc;

CREATE EXTENSION tablefunc WITH SCHEMA public;

DROP schema IF exists postgis;

CREATE EXTENSION postgis WITH SCHEMA public;

DROP EXTENSION IF exists "uuid-ossp";

CREATE EXTENSION "uuid-ossp" WITH SCHEMA public;

DROP EXTENSION IF exists unaccent;

CREATE EXTENSION unaccent WITH SCHEMA public;

DROP EXTENSION IF exists cube;

CREATE EXTENSION cube WITH SCHEMA public;

DROP EXTENSION IF exists ltree;

CREATE EXTENSION ltree WITH SCHEMA public;

DROP EXTENSION IF exists tablefunc;

CREATE EXTENSION tablefunc WITH SCHEMA public;