<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>