Re: Listing users - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Listing users
Date
Msg-id Pine.LNX.4.30.0110232117430.642-100000@peter.localdomain
Whole thread Raw
In response to Re: Listing users  (Keary Suska <hierophant@pcisys.net>)
Responses Re: Listing users
List pgsql-general
Keary Suska writes:

> The easiest way is to cat ~postgres/data/global/pg_pwd,

No way.

> 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).

That or SELECT * FROM pg_user;

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


pgsql-general by date:

Previous
From: Richard Welty
Date:
Subject: Re: openssl & postgresql
Next
From: "Steven Vajdic"
Date:
Subject: PostgreSQL 7.1.3 installation on Windows platforms