Home Explore Blog CI



postgresql

95th chunk of `doc/src/sgml/information_schema.sgml`
856b2f06f43e52fbd43f34f71a6171ea3c8df446292d73b90000000100000d9b
    <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>table_catalog</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the database that contains the view (always the current database)
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>table_schema</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the schema that contains the view
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>table_name</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the view
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>view_definition</structfield> <type>character_data</type>
      </para>
      <para>
       Query expression defining the view (null if the view is not
       owned by a currently enabled role)
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>check_option</structfield> <type>character_data</type>
      </para>
      <para>
       <literal>CASCADED</literal> or <literal>LOCAL</literal> if the view
       has a <literal>CHECK OPTION</literal> defined on it,
       <literal>NONE</literal> if not
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>is_updatable</structfield> <type>yes_or_no</type>
      </para>
      <para>
       <literal>YES</literal> if the view is updatable (allows
       <command>UPDATE</command> and <command>DELETE</command>),
       <literal>NO</literal> if not
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>is_insertable_into</structfield> <type>yes_or_no</type>
      </para>
      <para>
       <literal>YES</literal> if the view is insertable into (allows
       <command>INSERT</command>), <literal>NO</literal> if not
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>is_trigger_updatable</structfield> <type>yes_or_no</type>
      </para>
      <para>
       <literal>YES</literal> if the view has an <literal>INSTEAD OF</literal>
       <command>UPDATE</command> trigger defined on it, <literal>NO</literal> if not
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>is_trigger_deletable</structfield> <type>yes_or_no</type>
      </para>
      <para>
       <literal>YES</literal> if the view has an <literal>INSTEAD OF</literal>
       <command>DELETE</command> trigger defined on it, <literal>NO</literal> if not
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>is_trigger_insertable_into</structfield> <type>yes_or_no</type>
      </para>
      <para>
       <literal>YES</literal> if the view has an <literal>INSTEAD OF</literal>
       <command>INSERT</command> trigger defined on it, <literal>NO</literal> if not
      </para></entry>
     </row>
    </tbody>
   </tgroup>
  </table>
 </sect1>

</chapter>

Title: Information Schema: Views Table Columns
Summary
The views table in the information schema contains columns that describe the properties of views in the current database, including the database and schema names, view definition, check options, updatable status, and the presence of triggers for update, delete, and insert operations.