PostgreSQL 계정 생성

1 개요[ | ]

PostgreSQL CREATE ROLE
PostgreSQL 계정 생성
CREATE ROLE 계정명;

2 실행예시[ | ]

template1=# \du;
                             List of roles
 Role name |                   Attributes                   | Member of 
-----------+------------------------------------------------+-----------
 postgres  | Superuser, Create role, Create DB, Replication | {}
template1=# CREATE ROLE testuser;
CREATE ROLE
template1=# \du;
                             List of roles
 Role name |                   Attributes                   | Member of 
-----------+------------------------------------------------+-----------
 postgres  | Superuser, Create role, Create DB, Replication | {}
 testuser  | Cannot login                                   | {}

3 같이 보기[ | ]

문서 댓글 ({{ doc_comments.length }})
{{ comment.name }} {{ comment.created | snstime }}