Re: Listing users

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