Commitfe14b0d

committed

doc: Mention SET TABLESPACE clause for ALTER MATERIALIZED VIEW

This command flavor is supported, but there was nothing in thedocumentation about it.Author: Yugo NagataDiscussion:https://postgr.es/m/20220316133337.5dc9740abfa24c25ec9f67f5@sraoss.co.jpBackpatch-through: 10

1 parent88ae775 commitfe14b0dCopy full SHA for fe14b0d

File tree

-0

lines changed

-0

lines changed

Lines changed: 1 addition & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -42,6 +42,7 @@ ALTER MATERIALIZED VIEW ALL IN TABLESPACE <replaceable class="parameter">name</r`
`42`	`42`	`ALTER [ COLUMN ] <replaceable class="parameter">column_name</replaceable> SET STORAGE { PLAIN \| EXTERNAL \| EXTENDED \| MAIN }`
`43`	`43`	`CLUSTER ON <replaceable class="parameter">index_name</replaceable>`
`44`	`44`	`SET WITHOUT CLUSTER`
	`45`	`+ SET TABLESPACE <replaceable class="parameter">new_tablespace</replaceable>`
`45`	`46`	`SET ( <replaceable class="parameter">storage_parameter</replaceable> [= <replaceable class="parameter">value</replaceable>] [, ... ] )`
`46`	`47`	`RESET ( <replaceable class="parameter">storage_parameter</replaceable> [, ... ] )`
`47`	`48`	`OWNER TO { <replaceable class="parameter">new_owner</replaceable> \| CURRENT_USER \| SESSION_USER }`

Comments

(0)