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 /doc/src | |
| 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.
Diffstat (limited to 'doc/src')
| -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> |