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 
> Date: Tue, 23 Oct 2001 22:42:20 +0200 (CEST)
> To: Keary Suska 
> Cc: PostgreSQL 
> 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@gmx.net   http://funkturm.homeip.net/~peter
>