From: | Keary Suska <hierophant(at)pcisys(dot)net> |
---|---|
To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
Cc: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Listing users |
Date: | 2001-10-23 21:26:06 |
Message-ID: | B7FB3C8E.5279%hierophant@pcisys.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>> The easiest way is to cat ~postgres/data/global/pg_pwd,
>
> No way.
What does "no way" mean? That works on my installation (7.1.3). It may be
dependent on the authentication method used.
Keary Suska
Esoteritech, Inc.
"Leveraging Open Source for a better Internet"
> From: Peter Eisentraut <peter_e(at)gmx(dot)net>
> Date: Tue, 23 Oct 2001 22:42:20 +0200 (CEST)
> To: Keary Suska <hierophant(at)pcisys(dot)net>
> Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
> Subject: Re: [GENERAL] Listing users
>
> 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(at)gmx(dot)net http://funkturm.homeip.net/~peter
>
From | Date | Subject | |
---|---|---|---|
Next Message | Ernesto Baschny | 2001-10-23 21:27:42 | Re: oid not "UNIQUE" for use as FOREIGN KEY? |
Previous Message | Bruce Momjian | 2001-10-23 21:25:42 | Re: [GENERAL] To Postgres Devs : Wouldn't changing the selectlimit |