Postgresql drop role 命令不起作用

Postgresql drop role 命令不起作用

drop role 命令在我的 postgresql 11 中不起作用。我无法删除名为“ckdev”的角色。

 Role name |                         Attributes                         | Member of 
-----------+------------------------------------------------------------+-----------
 ckdev |                                                            | {}
 postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}

postgres-# drop role ckdev
postgres-# \du
                                   List of roles
 Role name |                         Attributes                         | Member of 
-----------+------------------------------------------------------------+-----------
 ckdev |                                                            | {}
 postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}

答案1

;SQL 命令末尾缺少什么?

drop role ckdev;

相关内容