Catalogs: pg_group

The view pg_group exists for backwards compatibility: it emulates a catalog that existed in PostgreSQL before version 8.1. It shows the names and members of all roles that are marked as not rolcanlogin, which is an approximation to the set of roles that are being used as groups.

Table 50-64. pg_group Columns

Name	Type	References	Description
`groname`	`name`	`pg_authid.rolname`	Name of the group
`grosysid`	`oid`	`pg_authid.oid`	ID of this group
`grolist`	`oid[]`	`pg_authid.oid`	An array containing the IDs of the roles in this group

Prev		Next
`pg_file_settings`	Up	`pg_indexes`

Links:

https://www.postgresql.org/docs/9.6/static/view-pg-group.html

doc_PostgreSQL

2016-10-12 11:32:31

Comments

Popular Articles

Catalogs: pg_statistic The catalog pg_statistic stores statistical data about the contents of the database. Entries are created by ANALYZE and subsequently used by the quer

Catalogs: pg_opclass The catalog pg_opclass defines index access method operator classes. Each operator class defines semantics for index columns of a particular data typ

Catalogs: pg_rewrite The catalog pg_rewrite stores rewrite rules for tables and views. Table 50-41. pg_rewrite Columns Name Type References Description oid oid Row id

Catalogs: pg_indexes The view pg_indexes provides access to useful information about each index in the database. Table 50-65. pg_indexes Columns Name Type References De

Catalogs: pg_constraint The catalog pg_constraint stores check, primary key, unique, foreign key, and exclusion constraints on tables. (Column constraints are not treated sp