init_postgresql_example.sql

-- Postgres 계정 생성 및 설정
CREATE ROLE sample_user WITH LOGIN PASSWORD 'sample_password';

-- Postgres 데이터베이스 생성
CREATE DATABASE sample_db WITH OWNER sample_user ENCODING 'UTF8' LC_COLLATE = 'ko_KR.UTF-8' LC_CTYPE = 'ko_KR.UTF-8';

-- sample_db 로 접속
\c sample_db;

-- DB 권한 부여
GRANT CONNECT ON DATABASE sample_db TO sample_user;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO sample_user;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO sample_user;
-- GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO sample_user;
-- GRANT USAGE ON SCHEMA public TO sample_user;

-- 이후 생성될 모든 DB 에 대해서도 권한 부여
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL PRIVILEGES ON TABLES TO sample_user;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL PRIVILEGES ON SEQUENCES TO sample_user;