15 lines
459 B
SQL
15 lines
459 B
SQL
CREATE DATABASE righttree;
|
|
CREATE USER righttree;
|
|
ALTER USER righttree WITH PASSWORD 'righttree';
|
|
|
|
\c righttree
|
|
CREATE EXTENSION IF NOT EXISTS postgis;
|
|
GRANT ALL ON geometry_columns TO PUBLIC;
|
|
GRANT ALL ON spatial_ref_sys TO PUBLIC;
|
|
|
|
CREATE SCHEMA IF NOT EXISTS linz;
|
|
ALTER SCHEMA linz OWNER TO righttree;
|
|
GRANT ALL PRIVILEGES ON SCHEMA linz TO righttree;
|
|
|
|
ALTER DATABASE righttree OWNER TO righttree;
|
|
GRANT ALL PRIVILEGES ON DATABASE righttree TO righttree;
|