Provided by: postgresql-client-8.0_8.0.7-2build1_i386 bug

NAME

       DROP USER - remove a database user account

SYNOPSIS

       DROP USER name

DESCRIPTION

       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.

PARAMETERS

       name   The name of the user to remove.

NOTES

       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
       its ownership.

       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.

EXAMPLES

       To drop a user account:

       DROP USER jonathan;

COMPATIBILITY

       The  DROP  USER  statement  is a PostgreSQL extension. The SQL standard
       leaves the definition of users to the implementation.

SEE ALSO

       ALTER USER [alter_user(7)], CREATE USER [create_user(l)]