Re: Re: How to list and remove a user in postgres ?

On Wed, Jul 12, 2000 at 07:45:50PM +0000, HomerWelch wrote:
> Fred wrote:
> >
> > Hi,
> >
> > I am a newby and i dont understand how to list al the users or delete them ?
> >
> > 1 do i it from the command line in Linux
> > 2 or in the database
> >
> > i have a user Fred and a user Grades and want delete them.
> >
>
> Go onto psql and type \h.  This will bring up topics that
> you can access by typing the backslash and the topic name
> (\h createuser.)  I don't recall a method for listing all
> users.


select * from pg_user;


reedstrm=>\h drop user
Command: drop user
Description: remove a user from the system
Syntax:
        DROP USER user_name;


HTH,
Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St.,  Houston, TX 77005