PostgreSQL 视图
视图是保存的查询：CREATE VIEW 定义、CREATE OR REPLACE 更新、DROP VIEW 删除。
Key PointsPostgreSQL,VIEW,视图,物化视图
讲解
视图是保存的查询：CREATE VIEW 定义、CREATE OR REPLACE 更新、DROP VIEW 删除。
示例
SQL
CREATE VIEW high_salary AS
SELECT id, name FROM company WHERE salary > 5000;
SELECT * FROM high_salary;
-- 物化视图：结果落盘、需 REFRESH 更新
CREATE MATERIALIZED VIEW hs_mat AS SELECT * FROM high_salary;Output
id | name
----+------
1 | Tom讲解
视图是保存的查询：CREATE VIEW 定义、CREATE OR REPLACE 更新、DROP VIEW 删除。
示例
SQL
CREATE VIEW high_salary AS
SELECT id, name FROM company WHERE salary > 5000;
SELECT * FROM high_salary;
-- 物化视图：结果落盘、需 REFRESH 更新
CREATE MATERIALIZED VIEW hs_mat AS SELECT * FROM high_salary;Output
id | name
----+------
1 | Tom