diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2014-10-13 22:17:34 -0400 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2014-10-13 22:22:20 -0400 |
| commit | db75e524856634ce1c41fc1233e85abbb716ef6e (patch) | |
| tree | 4a3e10280a135a30b88cc8aa2dfc75c15ed3e4c5 | |
| parent | 5dc4b50b028f430f639c74f5d449ac8ec27d3cf5 (diff) | |
| download | postgresql-db75e524856634ce1c41fc1233e85abbb716ef6e.tar.gz postgresql-db75e524856634ce1c41fc1233e85abbb716ef6e.zip | |
doc: Improve ALTER VIEW / SET documentation
The way the ALTER VIEW / SET options were listed in the synopsis was
very confusing. Move the list to the main description, similar to how
the ALTER TABLE reference page does it.
| -rw-r--r-- | doc/src/sgml/ref/alter_view.sgml | 40 |
1 files changed, 24 insertions, 16 deletions
diff --git a/doc/src/sgml/ref/alter_view.sgml b/doc/src/sgml/ref/alter_view.sgml index cdcc4f126ba..3aef61b67e6 100644 --- a/doc/src/sgml/ref/alter_view.sgml +++ b/doc/src/sgml/ref/alter_view.sgml @@ -28,11 +28,6 @@ ALTER VIEW [ IF EXISTS ] <replaceable class="parameter">name</replaceable> RENAM ALTER VIEW [ IF EXISTS ] <replaceable class="parameter">name</replaceable> SET SCHEMA <replaceable class="parameter">new_schema</replaceable> ALTER VIEW [ IF EXISTS ] <replaceable class="parameter">name</replaceable> SET ( <replaceable class="parameter">view_option_name</replaceable> [= <replaceable class="parameter">view_option_value</replaceable>] [, ... ] ) ALTER VIEW [ IF EXISTS ] <replaceable class="parameter">name</replaceable> RESET ( <replaceable class="parameter">view_option_name</replaceable> [, ... ] ) - -<phrase>where <replaceable class="parameter">view_option_name</replaceable> can be one of:</phrase> - - security_barrier [ <replaceable class="parameter">boolean</replaceable> ] - check_option [ <replaceable class="parameter">text</replaceable> (<literal>local</literal> or <literal>cascaded</literal>) ] </synopsis> </refsynopsisdiv> @@ -122,19 +117,32 @@ ALTER VIEW [ IF EXISTS ] <replaceable class="parameter">name</replaceable> RESET </varlistentry> <varlistentry> - <term><replaceable class="parameter">view_option_name</replaceable></term> - <listitem> - <para> - The name of a view option to be set or reset. - </para> - </listitem> - </varlistentry> - - <varlistentry> - <term><replaceable class="parameter">view_option_value</replaceable></term> + <term><literal>SET ( <replaceable class="parameter">view_option_name</replaceable> [= <replaceable class="parameter">view_option_value</replaceable>] [, ... ] )</literal></term> + <term><literal>RESET ( <replaceable class="parameter">view_option_name</replaceable> [, ... ] )</literal></term> <listitem> <para> - The new value for a view option. + Sets or resets a view option. Currently supported options are: + <variablelist> + <varlistentry> + <term><literal>check_option</literal> (<type>string</type>)</term> + <listitem> + <para> + Changes the check option of the view. The value must + be <literal>local</literal> or <literal>cascaded</literal>. + </para> + </listitem> + </varlistentry> + <varlistentry> + <term><literal>security_barrier</literal> (<type>boolean</type>)</term> + <listitem> + <para> + Changes the security-barrier property of the view. The value must + be Boolean value, such as <literal>true</literal> + or <literal>false</literal>. + </para> + </listitem> + </varlistentry> + </variablelist> </para> </listitem> </varlistentry> |