openGauss每日一练第11天 | 学习openGauss视图

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 ‘tom1@123’;
alter view v_view owner to jim;

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

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

insert into tom.student values (1,‘tom’,‘male’),(2,‘dd’,‘frre’);

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

alter view tom.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 tom.student;
drop user jim;
drop schema tom;