From 590eb0c14eebe834f716721a9659b77899cf3084 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Mon, 13 Oct 2014 22:17:34 -0400 Subject: [PATCH] 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. --- doc/src/sgml/ref/alter_view.sgml | 40 +++++++++++++++++++------------- 1 file changed, 24 insertions(+), 16 deletions(-) diff --git a/doc/src/sgml/ref/alter_view.sgml b/doc/src/sgml/ref/alter_view.sgml index cdcc4f126b..3aef61b67e 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 ] name RENAM ALTER VIEW [ IF EXISTS ] name SET SCHEMA new_schema ALTER VIEW [ IF EXISTS ] name SET ( view_option_name [= view_option_value] [, ... ] ) ALTER VIEW [ IF EXISTS ] name RESET ( view_option_name [, ... ] ) - -where view_option_name can be one of: - - security_barrier [ boolean ] - check_option [ text (local or cascaded) ] @@ -122,19 +117,32 @@ ALTER VIEW [ IF EXISTS ] name RESET - view_option_name - - - The name of a view option to be set or reset. - - - - - - view_option_value + SET ( view_option_name [= view_option_value] [, ... ] ) + RESET ( view_option_name [, ... ] ) - The new value for a view option. + Sets or resets a view option. Currently supported options are: + + + check_option (string) + + + Changes the check option of the view. The value must + be local or cascaded. + + + + + security_barrier (boolean) + + + Changes the security-barrier property of the view. The value must + be Boolean value, such as true + or false. + + + + -- 2.40.0