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(at)rice(dot)edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005