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_language The catalog pg_language registers languages in which you can write functions or stored procedures. See CREATE LANGUAGE and Chapter 40 for more inform

Catalogs: pg_shdepend The catalog pg_shdepend records the dependency relationships between database objects and shared objects, such as roles. This information allows Post

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_constraint The catalog pg_constraint stores check, primary key, unique, foreign key, and exclusion constraints on tables. (Column constraints are not treated sp

Catalogs: pg_matviews The view pg_matviews provides access to useful information about each materialized view in the database. Table 50-67. pg_matviews Columns Name Type