Re: Role information table name

Greetings,

* Gaurav Tomar (gauravtomar14(at)gmail(dot)com) wrote:
> Simple question -- in which table postgres store the role
> privilege information.
>
> CREATE ROLE postgres WITH
> LOGIN
> SUPERUSER
> INHERIT
> CREATEDB
> CREATEROLE
> REPLICATION;
>
> in which table I can find the above information.

While this is in pg_authid, if that's all the info you want to find out,
you should probably be getting it from pg_roles (which is a view over
pg_authid), since you need to be GRANT'd access to pg_authid unless
you're a superuser.

Thanks,

Stephen