diff options
| author | Michael Paquier <michael@paquier.xyz> | 2022-03-19 16:38:02 +0900 |
|---|---|---|
| committer | Michael Paquier <michael@paquier.xyz> | 2022-03-19 16:38:02 +0900 |
| commit | 49c5cd5c4e7ac408dc0ae64fa77b16a4e0c63c8b (patch) | |
| tree | f85694794c403396f4a33d87a592a579c791155a | |
| parent | e6fd4a3daff6e9d2a5dcceeae90a4b01bf1b7645 (diff) | |
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
| -rw-r--r-- | doc/src/sgml/ref/alter_materialized_view.sgml | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/alter_materialized_view.sgml b/doc/src/sgml/ref/alter_materialized_view.sgml index e27d38df19d..4b2e822d933 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 } |