CREATE USER aluvisa WITH ENCRYPTED PASSWORD '**asivula**' LOGIN SUPERUSER INHERIT CREATEDB CREATEROLE REPLICATION;
|
|
CREATE TABLESPACE "ARTIC" OWNER aluvisa LOCATION 'E:\\database\\ARTIC';
|
ALTER TABLESPACE "ARTIC" OWNER TO aluvisa;
|
CREATE DATABASE "ARTIC" WITH OWNER = aluvisa TEMPLATE = 'template0' ENCODING = 'UTF8' LC_COLLATE = 'C' LC_CTYPE = 'C' TABLESPACE = "ARTIC" CONNECTION LIMIT = -1;
|
|
|
CREATE TABLESPACE "ARTICHISTORICAL" OWNER aluvisa LOCATION 'E:\\database\\ARTICHISTORICAL';
|
ALTER TABLESPACE "ARTICHISTORICAL" OWNER TO aluvisa;
|
CREATE DATABASE "ARTICHISTORICAL" WITH OWNER = aluvisa TEMPLATE = 'template0' ENCODING = 'UTF8' LC_COLLATE = 'C' LC_CTYPE = 'C' TABLESPACE = "ARTICHISTORICAL" CONNECTION LIMIT = -1;
|
