<HTML ><HEAD ><TITLE >pg_group</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.73 "><LINK REV="MADE" HREF="mailto:pgsql-docs@postgresql.org"><LINK REL="HOME" TITLE="PostgreSQL 7.3.2 Documentation" HREF="index.html"><LINK REL="UP" TITLE="System Catalogs" HREF="catalogs.html"><LINK REL="PREVIOUS" TITLE="pg_description" HREF="catalog-pg-description.html"><LINK REL="NEXT" TITLE="pg_index" HREF="catalog-pg-index.html"><LINK REL="STYLESHEET" TYPE="text/css" HREF="stylesheet.css"><META NAME="creation" CONTENT="2003-02-03T20:17:34"></HEAD ><BODY CLASS="SECT1" BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#840084" ALINK="#0000FF" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="3" ALIGN="center" >PostgreSQL 7.3.2 Documentation</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="catalog-pg-description.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" >Chapter 3. System Catalogs</TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="catalog-pg-index.html" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><DIV CLASS="SECT1" ><H1 CLASS="SECT1" ><A NAME="CATALOG-PG-GROUP" >3.15. pg_group</A ></H1 ><P > This catalog defines groups and stores what users belong to what groups. Groups are created with the <TT CLASS="COMMAND" >CREATE GROUP</TT > command. Consult the <I CLASS="CITETITLE" >Administrator's Guide</I > for information about user permission management. </P ><P > Because user and group identities are cluster-wide, <TT CLASS="STRUCTNAME" >pg_group</TT > is shared across all databases of a cluster: there is only one copy of <TT CLASS="STRUCTNAME" >pg_group</TT > per cluster, not one per database. </P ><DIV CLASS="TABLE" ><A NAME="AEN53435" ></A ><P ><B >Table 3-15. pg_group Columns</B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><THEAD ><TR ><TH ALIGN="LEFT" VALIGN="TOP" >Name</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Type</TH ><TH ALIGN="LEFT" VALIGN="TOP" >References</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Description</TH ></TR ></THEAD ><TBODY ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >groname</TD ><TD ALIGN="LEFT" VALIGN="TOP" ><TT CLASS="TYPE" >name</TT ></TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" >Name of the group</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >grosysid</TD ><TD ALIGN="LEFT" VALIGN="TOP" ><TT CLASS="TYPE" >int4</TT ></TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" >An arbitrary number to identify this group</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >grolist</TD ><TD ALIGN="LEFT" VALIGN="TOP" ><TT CLASS="TYPE" >int4[]</TT ></TD ><TD ALIGN="LEFT" VALIGN="TOP" >pg_shadow.usesysid</TD ><TD ALIGN="LEFT" VALIGN="TOP" >An array containing the ids of the users in this group</TD ></TR ></TBODY ></TABLE ></DIV ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="catalog-pg-description.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="catalog-pg-index.html" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >pg_description</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="catalogs.html" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >pg_index</TD ></TR ></TABLE ></DIV ></BODY ></HTML >