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;