Provided by: postgresql-client-8.0_8.0.7-2build1_i386
DROP USER - remove a database user account
DROP USER name
DROP USER removes the specified user. It does not remove tables,
views, or other objects owned by the user. If the user owns any
database, an error is raised.
name The name of the user to remove.
PostgreSQL includes a program dropuser [dropuser(1)] that has the same
functionality as this command (in fact, it calls this command) but can
be run from the command shell.
To drop a user who owns a database, first drop the database or change
It is unwise to drop a user who either owns any database objects or has
any granted permissions on objects. Currently, this is only enforced
for the case of owners of databases, but it is likely that future
versions of PostgreSQL will check other cases.
To drop a user account:
DROP USER jonathan;
The DROP USER statement is a PostgreSQL extension. The SQL standard
leaves the definition of users to the implementation.
ALTER USER [alter_user(7)], CREATE USER [create_user(l)]