Home Explore Blog CI



postgresql

33th chunk of `doc/src/sgml/system-views.sgml`
0d22d87bb60d17788e3337618b6424c63ba4263a4cf0aff40000000100000fb9
    <listitem>
         <para>
          <literal>rows_removed</literal> means that the required rows have
          been removed. It is set only for logical slots.
         </para>
        </listitem>
        <listitem>
         <para>
          <literal>wal_level_insufficient</literal> means that the
          primary doesn't have a <xref linkend="guc-wal-level"/> sufficient to
          perform logical decoding.  It is set only for logical slots.
         </para>
        </listitem>
        <listitem>
         <para>
          <literal>idle_timeout</literal> means that the slot has remained
          idle longer than the configured
          <xref linkend="guc-idle-replication-slot-timeout"/> duration.
         </para>
        </listitem>
       </itemizedlist>
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>failover</structfield> <type>bool</type>
      </para>
      <para>
       True if this is a logical slot enabled to be synced to the standbys
       so that logical replication can be resumed from the new primary
       after failover. Always false for physical slots.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>synced</structfield> <type>bool</type>
      </para>
      <para>
       True if this is a logical slot that was synced from a primary server.
       On a hot standby, the slots with the synced column marked as true can
       neither be used for logical decoding nor dropped manually. The value
       of this column has no meaning on the primary server; the column value on
       the primary is default false for all slots but may (if leftover from a
       promoted standby) also be true.
      </para></entry>
     </row>

    </tbody>
   </tgroup>
  </table>
 </sect1>

 <sect1 id="view-pg-roles">
  <title><structname>pg_roles</structname></title>

  <indexterm zone="view-pg-roles">
   <primary>pg_roles</primary>
  </indexterm>

  <para>
   The view <structname>pg_roles</structname> provides access to
   information about database roles.  This is simply a publicly
   readable view of
   <link linkend="catalog-pg-authid"><structname>pg_authid</structname></link>
   that blanks out the password field.
  </para>

  <table>
   <title><structname>pg_roles</structname> Columns</title>
   <tgroup cols="1">
    <thead>
     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       Column Type
      </para>
      <para>
       Description
      </para></entry>
     </row>
    </thead>

    <tbody>
     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>rolname</structfield> <type>name</type>
      </para>
      <para>
       Role name
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>rolsuper</structfield> <type>bool</type>
      </para>
      <para>
       Role has superuser privileges
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>rolinherit</structfield> <type>bool</type>
      </para>
      <para>
       Role automatically inherits privileges of roles it is a
       member of
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>rolcreaterole</structfield> <type>bool</type>
      </para>
      <para>
       Role can create more roles
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>rolcreatedb</structfield> <type>bool</type>
      </para>
      <para>
       Role can create databases
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>rolcanlogin</structfield>

Title: Database Roles View: pg_roles
Summary
The pg_roles view provides information about database roles, including role names, superuser privileges, inheritance of privileges, and abilities to create roles and databases, offering a publicly readable alternative to pg_authid with the password field blanked out.