Re: [HACKERS] psql \du and \dg is the same - pg 8.4

2009-07-21 Thread Andreas Wenk
Tom Lane wrote: ANdreas Wenk writes: actually I discovered that using \du and \dg in psql is providing the same result: Yup. The psql documentation says as much. ok - got it ;-) Should have read the psql docu ... I am wondering why there is \dg at all. Users and groups used to be dist

Re: [HACKERS] psql \du and \dg is the same - pg 8.4

2009-07-21 Thread Tom Lane
ANdreas Wenk writes: > actually I discovered that using \du and \dg in psql is providing the > same result: Yup. The psql documentation says as much. > I am wondering why there is \dg at all. Users and groups used to be distinct kinds of objects. They aren't anymore, but people might still b

[HACKERS] psql \du and \dg is the same - pg 8.4

2009-07-21 Thread ANdreas Wenk
Hi, actually I discovered that using \du and \dg in psql is providing the same result: book=# \du * QUERY ** SELECT r.rolname, r.rolsuper, r.rolinherit, r.rolcreaterole, r.rolcreatedb, r.rolcanlogin, r.rolconnlimit, ARRAY(SELECT b.rolname FROM pg_catalog.pg_auth_m