openGauss每日一练第11天 | 视图的基本管理

1.为系统表PG_DATABASE创建视图，重命名视图并修改owner为jim

CREATE VIEW eason_view AS SELECT * FROM pg_database;

alter view eason_view rename to v_view;

create user jim password 'abcd@123';
alter view v_view owner to jim;

复制

2.创建一个用户表student，并在用户表上创建视图，修改视图schema

create schema hyj;
create table hyj.student 
( id int,
name char(20),
sex char(20)
);

insert into hyj.student values (1,'hyj','male'),(2,'frey','female');

create view hyj.v_student as select * from hyj.student;

alter view hyj.v_student set schema jim;
复制

3.使用pg_views查看视图信息

select * from pg_views where viewname='v_student';
复制

4.删除视图、表、用户

drop view jim.v_student;
drop v_view;
drop table hyj.student;
drop user jim;
drop schema hyj;
复制