Re: Listing users

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Keary Suska <hierophant(at)pcisys(dot)net>
Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Listing users
Date: 2001-10-23 20:42:20
Message-ID: Pine.LNX.4.30.0110232117430.642-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmx(dot)net http://funkturm.homeip.net/~peter

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2001-10-23 20:42:36 Re: Dump Error...
Previous Message Peter Eisentraut 2001-10-23 20:42:11 Re: [GENERAL] To Postgres Devs : Wouldn't changing the select limit