9 lines
367 B
SQL
9 lines
367 B
SQL
CREATE ROLE sahanademo NOSUPERUSER NOCREATEDB NOCREATEROLE NOINHERIT LOGIN ENCRYPTED PASSWORD '${SAHANADEMO_PWD}';
|
|
CREATE DATABASE sahanademo;
|
|
REVOKE ALL ON DATABASE sahanademo FROM public;
|
|
ALTER DATABASE sahanademo OWNER TO sahanademo;
|
|
\c sahanademo;
|
|
CREATE EXTENSION postgis;
|
|
GRANT ALL ON geometry_columns TO sahanademo;
|
|
GRANT ALL ON spatial_ref_sys TO sahanademo;
|