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.vanderMee@amc.uva.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?
--