07-30-2023, 12:31 PM
I have the following postgres users which I can view by invoking the `\du` command in the terminal as follows:
postgres=# \du
List of roles
Role name | Attributes | Member of
-----------+------------------------------------------------+-----------
postgres | Superuser, Create role, Create DB, Replication | {}
tutorial1 | | {}
According to the [postgres documentation][1], I should be able to drop the user called "tutorial1" by entering the following command:
postgres=# DROP USER tutorial1
However, when I use that command nothing happens. The documentation doesn't provide any hints as to why this isn't working, nor does it provide clear examples.
That being said-- what is the command to drop this user?
[1]:
postgres=# \du
List of roles
Role name | Attributes | Member of
-----------+------------------------------------------------+-----------
postgres | Superuser, Create role, Create DB, Replication | {}
tutorial1 | | {}
According to the [postgres documentation][1], I should be able to drop the user called "tutorial1" by entering the following command:
postgres=# DROP USER tutorial1
However, when I use that command nothing happens. The documentation doesn't provide any hints as to why this isn't working, nor does it provide clear examples.
That being said-- what is the command to drop this user?
[1]:
[To see links please register here]