REFRESH INCREMENTAL MATERIALIZED VIEW

    注意事项

    • 增量刷新仅支持增量物化视图。
    • 刷新物化视图需要当前用户拥有基表的SELECT权限。

    参数说明

    2. openGauss=# CREATE TABLE my_table (c1 int, c2 int);
    3. openGauss=# CREATE INCREMENTAL MATERIALIZED VIEW my_imv AS SELECT * FROM my_table;
    5. openGauss=# INSERT INTO my_table VALUES(1,1),(2,2);
    7. openGauss=# REFRESH INCREMENTAL MATERIALIZED VIEW my_imv;

    相关链接