PostgreSQL 계정 삭제

1 개요[ | ]

PostgreSQL DROP ROLE
PostgreSQL 계정 삭제

sql

Copy

DROP ROLE 계정명;

2 실행예시[ | ]

Console

Copy

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

Console

Copy

template1=# DROP ROLE testuser;
DROP ROLE

Console

Copy

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

3 같이 보기[ | ]