pg 视图 创建修改删除
2022-08-02 本文已影响0人
饱饱想要灵感
创建视图
create view children_view as SELECT *
FROM user
WHERE age < 13;
修改视图
create or replace view children_view as SELECT *
FROM user
WHERE age <= 13;
删除视图
drop view children_view;
创建视图
create view children_view as SELECT *
FROM user
WHERE age < 13;
修改视图
create or replace view children_view as SELECT *
FROM user
WHERE age <= 13;
删除视图
drop view children_view;