Re: Listing users

The easiest way is to cat ~postgres/data/global/pg_pwd, but if that doesn't
tell you what you need to know, you can SELECT * FROM pg_shadow (works when
connected to any database as long as you are the postgres superuser).

Keary Suska
Esoteritech, Inc.
"Leveraging Open Source for a better Internet"

> From: "Aaron Rouse" <pgsql(at)happyhacker(dot)com>
> Date: Sun, 21 Oct 2001 21:51:06 -0500
> To: <pgsql-general(at)postgresql(dot)org>
> Subject: [GENERAL] Listing users
>
> I am trying to connect to a PGSQL 7.1.3 using PGAdmin II and I am
> getting a error that says the user I am trying to connect with does not
> exist. How can I get a list of the users in the database from the psql
> console when su'd to the postgres user?
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>