From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
---|---|
To: | Thanh Q Lam <thanh(dot)q(dot)lam(at)alcatel(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: How to list user accounts? |
Date: | 2005-07-12 19:12:25 |
Message-ID: | 1121195544.8208.242.camel@state.g2switchworks.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Tue, 2005-07-12 at 13:59, Thanh Q Lam wrote:
> Hi,
>
> Is there a command/option to list all database user accounts in postgres?
>From the psql monitor:
\du
via sql:
SELECT u.usename AS "User name",
u.usesysid AS "User ID",
CASE WHEN u.usesuper AND u.usecreatedb THEN CAST('superuser, create
database' AS pg_catalog.text)
WHEN u.usesuper THEN CAST('superuser' AS pg_catalog.text)
WHEN u.usecreatedb THEN CAST('create database' AS
pg_catalog.text)
ELSE CAST('' AS pg_catalog.text)
END AS "Attributes"
FROM pg_catalog.pg_user u
ORDER BY 1;
(what psql does behind the scenes when you type \du)
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2005-07-12 19:16:58 | Re: How to list user accounts? |
Previous Message | Bruno Wolff III | 2005-07-12 19:10:53 | Re: How to list user accounts? |