Re: Role Membership

On Mon, Dec 20, 2010 at 9:12 AM, Carlos Mennens
<carlos(dot)mennens(at)gmail(dot)com> wrote:
> So if I wanted to create a group / role for accounting, would I simply just do:
>
> CREATE ROLE accounting;
>
> My question is I can't find:
>
> 1. How to view all previously created roles on my database. '\dg'
> doesn't show me the new role I created above.

Odd, mine does. Got a complete example of creating a role and not seeing it?

Here's mine:
smarlowe=# create role stans;
CREATE ROLE
smarlowe=# \dg
List of roles
Role name | Attributes | Member of
-----------+--------------+-----------
postgres | Superuser | {}
: Create role
: Create DB
smarlowe | Superuser | {}
: Create role
: Create DB
stans | Cannot login | {}

> 2. How to see which 'users' are all members of 'accounting'? Would
> that be done simply with '\dg'?

Yeah.