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;