postgres.git / summary / log / commit / refs

commit    4d232292518736e64134d9d6bef6ca08f44dfdc4
Author:   Michael Paquier <michael@paquier.xyz>
Date:     Sat Mar 19 07:37:52 2022 +0000
First released in: 15.0, 10.21, 11.16, 12.11, 13.7, 14.3

    doc: Mention SET TABLESPACE clause for ALTER MATERIALIZED VIEW
    
    This command flavor is supported, but there was nothing in the
    documentation about it.
    
    Author: Yugo Nagata
    Discussion: https://postgr.es/m/20220316133337.5dc9740abfa24c25ec9f67f5@sraoss.co.jp
    Backpatch-through: 10


 doc/src/sgml/ref/alter_materialized_view.sgml | 1 +
 1 file changed, 1 insertion(+)

diff --git a/doc/src/sgml/ref/alter_materialized_view.sgml b/doc/src/sgml/ref/alter_materialized_view.sgml
index 4ee389275c6..8428664e763 100644
--- a/doc/src/sgml/ref/alter_materialized_view.sgml
+++ b/doc/src/sgml/ref/alter_materialized_view.sgml
@@ -42,6 +42,7 @@ ALTER MATERIALIZED VIEW ALL IN TABLESPACE <replaceable class="parameter">name</r
     ALTER [ COLUMN ] <replaceable class="parameter">column_name</replaceable> SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN }
     CLUSTER ON <replaceable class="parameter">index_name</replaceable>
     SET WITHOUT CLUSTER
+    SET TABLESPACE <replaceable class="parameter">new_tablespace</replaceable>
     SET ( <replaceable class="parameter">storage_parameter</replaceable> [= <replaceable class="parameter">value</replaceable>] [, ... ] )
     RESET ( <replaceable class="parameter">storage_parameter</replaceable> [, ... ] )
     OWNER TO { <replaceable class="parameter">new_owner</replaceable> | CURRENT_USER | SESSION_USER }


[parent: 840729fd104e]