aboutsummaryrefslogtreecommitdiffstats
path: root/install/template-stif-boiv.sql
blob: 4d4a19afee664f30fc5098459c1fdf5465dcd3a9 (plain)
1
2
3
4
5
6
7
8
9
10
11
set ON_ERROR_STOP=on;

CREATE SCHEMA shared_extensions;
GRANT ALL ON SCHEMA shared_extensions TO PUBLIC;
CREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA shared_extensions;
CREATE EXTENSION IF NOT EXISTS hstore WITH SCHEMA shared_extensions;

UPDATE pg_database SET datistemplate = TRUE WHERE datname = 'template_stif_boiv';

VACUUM FULL FREEZE;