1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
|
ALTER MATERIALIZED VIEW bar ALTER column_name SET STATISTICS 1;
ALTER MATERIALIZED VIEW bar ALTER COLUMN column_name SET STATISTICS 1;
ALTER MATERIALIZED VIEW bar ALTER column_name SET ( attribute_option = 1);
ALTER MATERIALIZED VIEW bar ALTER COLUMN column_name SET (
attribute_option1 = 'avalue', attribute_option2 = 'avalue'
);
ALTER MATERIALIZED VIEW bar ALTER column_name RESET ( attribute_option );
ALTER MATERIALIZED VIEW bar ALTER column_name RESET (
attribute_option, attribute_option2
);
ALTER MATERIALIZED VIEW bar ALTER COLUMN column_name RESET ( attribute_option );
ALTER MATERIALIZED VIEW bar ALTER COLUMN column_name RESET (
attribute_option, attribute_option2
);
ALTER MATERIALIZED VIEW bar ALTER column_name SET STORAGE PLAIN;
ALTER MATERIALIZED VIEW bar ALTER COLUMN column_name SET STORAGE EXTENDED;
ALTER MATERIALIZED VIEW bar CLUSTER ON index_name;
ALTER MATERIALIZED VIEW bar SET WITHOUT CLUSTER;
ALTER MATERIALIZED VIEW bar SET ( storage_parameter);
ALTER MATERIALIZED VIEW bar SET ( storage_parameter, storage_parameter);
ALTER MATERIALIZED VIEW bar SET (
storage_parameter = 'some_value', storage_parameter
);
ALTER MATERIALIZED VIEW bar RESET ( storage_parameter);
ALTER MATERIALIZED VIEW bar RESET ( storage_parameter, storage_parameter);
ALTER MATERIALIZED VIEW bar OWNER TO baz_role;
ALTER MATERIALIZED VIEW bar OWNER TO "baz-role";
ALTER MATERIALIZED VIEW bar DEPENDS ON EXTENSION baz;
ALTER MATERIALIZED VIEW bar NO DEPENDS ON EXTENSION baz;
ALTER MATERIALIZED VIEW bar RENAME column_name TO new_column_name;
ALTER MATERIALIZED VIEW IF EXISTS bar RENAME COLUMN column_name TO new_column_name;
ALTER MATERIALIZED VIEW bar RENAME TO baz;
ALTER MATERIALIZED VIEW IF EXISTS bar RENAME TO baz;
ALTER MATERIALIZED VIEW bar SET SCHEMA new_schema;
ALTER MATERIALIZED VIEW IF EXISTS bar SET SCHEMA new_schema;
ALTER MATERIALIZED VIEW ALL IN TABLESPACE old_tablespace SET TABLESPACE new_tablespace;
ALTER MATERIALIZED VIEW ALL IN TABLESPACE old_tablespace SET TABLESPACE new_tablespace NOWAIT;
ALTER MATERIALIZED VIEW ALL IN TABLESPACE old_tablespace OWNED BY role_name SET TABLESPACE new_tablespace;
ALTER MATERIALIZED VIEW ALL IN TABLESPACE old_tablespace OWNED BY role_name SET TABLESPACE new_tablespace NOWAIT;
ALTER MATERIALIZED VIEW ALL IN TABLESPACE old_tablespace OWNED BY role_name,
role_name_2 SET TABLESPACE new_tablespace;
ALTER MATERIALIZED VIEW ALL IN TABLESPACE old_tablespace OWNED BY role_name,
role_name_2 SET TABLESPACE new_tablespace NOWAIT;
|
