blob: 3014dc0a16ac742df68e12d17f093fb321fbdffb (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
-- setup_db.sql
-- Create user (if it doesn't exist)
DO
$$
BEGIN
IF NOT EXISTS (
SELECT FROM pg_catalog.pg_roles WHERE rolname = 'silmataivas'
) THEN
CREATE ROLE silmataivas LOGIN PASSWORD 'silmataivas';
END IF;
END
$$;
-- Create database owned by the user
CREATE DATABASE silmataivas OWNER silmataivas;
-- Optional: grant all privileges explicitly
GRANT ALL PRIVILEGES ON DATABASE silmataivas TO silmataivas;
|
