目录

ALTER MATERIALIZED VIEW

一个用于修改物化视图定义的SQL命令

ALTER MATERIALIZED VIEW 是一个用于修改物化视图定义的DDL命令。

ALTER MATERIALIZED VIEW 在 PostgreSQL 9.3 中添加。

变更历史

示例

ALTER MATERIALIZED VIEW 的基本用法示例

postgres=# CREATE TABLE foo (id INT, val TEXT);
CREATE TABLE

postgres=# INSERT INTO foo VALUES(1, 'bar');
INSERT 0 1

postgres=# CREATE MATERIALIZED VIEW bar AS SELECT * FROM foo;
SELECT 1

postgres=# \d bar
          Materialized view "public.bar"
 Column |  Type   | Collation | Nullable | Default 
--------+---------+-----------+----------+---------
 id     | integer |           |          | 
 val    | text    |           |          | 

postgres=# ALTER MATERIALIZED VIEW bar RENAME val TO foo_val;
ALTER MATERIALIZED VIEW

postgres=# \d bar
           Materialized view "public.bar"
 Column  |  Type   | Collation | Nullable | Default 
---------+---------+-----------+----------+---------
 id      | integer |           |          | 
 foo_val | text    |           |          |

分类

DDL

另请参阅

REFRESH MATERIALIZED VIEW, CREATE MATERIALIZED VIEW, DROP MATERIALIZED VIEW

反馈

在此处提交任何关于“ALTER MATERIALIZED VIEW”的评论、建议或更正 here。