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_class The catalog pg_class catalogs tables and most everything else that has columns or is otherwise similar to a table. This includes indexes (but see als

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_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_shdepend The catalog pg_shdepend records the dependency relationships between database objects and shared objects, such as roles. This information allows Post

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