Home Explore Blog CI



postgresql

16th chunk of `doc/src/sgml/system-views.sgml`
268a1b9d901e82eb4dbd20c877053029b9cb8cb55ab475e00000000100000fd9
 in this view for each non-empty, non-comment line in the file,
   with annotations indicating whether the map could be applied successfully.
  </para>

  <para>
   This view can be helpful for checking whether planned changes in the
   authentication configuration file will work, or for diagnosing a previous
   failure.  Note that this view reports on the <emphasis>current</emphasis>
   contents of the file, not on what was last loaded by the server.
  </para>

  <para>
   By default, the <structname>pg_ident_file_mappings</structname> view can be
   read only by superusers.
  </para>

  <table>
   <title><structname>pg_ident_file_mappings</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>map_number</structfield> <type>int4</type>
      </para>
      <para>
       Number of this map, in priority order, if valid, otherwise
       <literal>NULL</literal>
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>file_name</structfield> <type>text</type>
      </para>
      <para>
       Name of the file containing this map
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>line_number</structfield> <type>int4</type>
      </para>
      <para>
       Line number of this map in <literal>file_name</literal>
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>map_name</structfield> <type>text</type>
      </para>
      <para>
       Name of the map
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>sys_name</structfield> <type>text</type>
      </para>
      <para>
       Detected user name of the client
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>pg_username</structfield> <type>text</type>
      </para>
      <para>
       Requested PostgreSQL user name
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>error</structfield> <type>text</type>
      </para>
      <para>
       If not <literal>NULL</literal>, an error message indicating why this
       line could not be processed
      </para></entry>
     </row>
    </tbody>
   </tgroup>
  </table>

  <para>
   Usually, a row reflecting an incorrect entry will have values for only
   the <structfield>line_number</structfield> and <structfield>error</structfield> fields.
  </para>

  <para>
   See <xref linkend="client-authentication"/> for more information about
   client authentication configuration.
  </para>
 </sect1>

 <sect1 id="view-pg-indexes">
  <title><structname>pg_indexes</structname></title>

  <indexterm zone="view-pg-indexes">
   <primary>pg_indexes</primary>
  </indexterm>

  <para>
   The view <structname>pg_indexes</structname> provides access to
   useful information about each index in the database.
  </para>

  <table>
   <title><structname>pg_indexes</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>schemaname</structfield> <type>name</type>
       (references <link linkend="catalog-pg-namespace"><structname>pg_namespace</structname></link>.<structfield>nspname</structfield>)

Title: pg_indexes and pg_ident_file_mappings Views
Summary
The pg_ident_file_mappings view displays the client user name mapping configuration, while the pg_indexes view provides information about each index in the database. The pg_ident_file_mappings view includes details such as map number, file name, line number, map name, and error messages, and can be used to check planned changes or diagnose previous failures in authentication configuration. On the other hand, the pg_indexes view offers access to useful information about each index, including schemaname.