a pretty way to view group members?

[Andrew Hammond]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Does anyone have a pretty way view the members of a group?
How about a list of groups which a user is in?

Or do I need to re-invent this wheel?

- --
Andrew Hammond 416-673-4138 ***@ca.afilias.info
Database Administrator, Afilias Canada Corp.
CB83 2838 4B67 D40F D086 3568 81FC E7E5 27AF 4A9A
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFBN2PVgfzn5SevSpoRAoBkAKCPfBdcGCtnGBU2WtZVptiv/83YRgCgl13k
BaT2O2ot3Moow5l/ht11EUA=
=NvV3
-----END PGP SIGNATURE-----

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[CoL]

hi,

Post by Andrew Hammond
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Does anyone have a pretty way view the members of a group?
How about a list of groups which a user is in?

SELECT groname,usename from pg_group,pg_user where usesysid = any(grolist);

C.

[Bruce Momjian]

Andrew Hammond wrote:
[ PGP not available, raw data follows ]

Post by Andrew Hammond
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Does anyone have a pretty way view the members of a group?
How about a list of groups which a user is in?
Or do I need to re-invent this wheel?

8.0 will have \dg and \du will show groups.
--
Bruce Momjian | http://candle.pha.pa.us
***@candle.pha.pa.us | [phone]
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html