Postgresql Drop Role Command Not Working

drop role command not working in my postgresql 11. I can't delete the role named '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 | {}
0

1 Answer

Missing ; at the end of sql command?

drop role ckdev;
1

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Maya Lin-Takahashi

Maya Lin-Takahashi

Consumer Tech & Gadget Reviewer

Maya is a hardware enthusiast who tests and reviews smart home devices, smartphones, wearables, and audio gear. She focuses on practical consumer value and build quality.

Share this article
Twitter Facebook Pinterest