PostgreSQL create database and user

GOAL

PostgreSQL でデータベースの作成とユーザの作成

Creating a database and user in PostgreSQL

ENVIRONMENT

• PostgreSQL 10+

PARAMETER

database encoding

PARAM_01:
default: UTF8

database name

PARAM_02:

user name

PARAM_03:

user password

PARAM_04:

host name

PARAM_05:

CODE

create database

CREATE DATABASE [PARAM_02] LC_COLLATE '[PARAM_01]' LC_CTYPE '[PARAM_01]' TEMPLATE template0;

create user

CREATE USER [PARAM_03] WITH PASSWORD '[PARAM_04]';

grant user

GRANT ALL ON [PARAM_01].* to '[PARAM_02]'@'%';
GRANT ALL ON [PARAM_01].* to '[PARAM_02]'@'localhost';

grant user with host name

GRANT ALL ON [PARAM_01].* to '[PARAM_02]'@'[PARAM_04]';