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

To list all known users you can query pg_users.

select * from pg_users;

If you want to see there passwords

select * from pg_shadow;

Merlijn

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.
>
> Thanks
>
> Fred

--
Merlijn van der Mee - Bioinformatician
Academic Medical Centre - Amsterdam
Bioinformatics Laboratory
Email: M(dot)vanderMee(at)amc(dot)uva(dot)nl tel. +31-20-5668601
-
Version: 3.1
GCS d- s+:- a- C+++ UL++ P++++ L+++ E---- W++ N o-- K- w---
O M-- V-- PS+++ PE- Y+ PGP+ t+ 5 X- R+ tv-- b+ DI-- D++
G e* h- r--- y?
--