7 lines
250 B
SQL
7 lines
250 B
SQL
CREATE ROLE sigmah NOSUPERUSER NOCREATEDB NOCREATEROLE NOINHERIT LOGIN ENCRYPTED PASSWORD '${SIGMAH_PWD}';
|
|
CREATE DATABASE sigmah;
|
|
REVOKE ALL ON DATABASE sigmah FROM public;
|
|
ALTER DATABASE sigmah OWNER TO sigmah;
|
|
\c sigmah;
|
|
CREATE EXTENSION pg_trgm;
|