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

自己安装的openGauss环境
启动openGauss
gs_ctl -D /gauss/data/db1/ start
登录openGauss
gsql -d postgres -p 26000 -r

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

create schema hc;
create view hc.pg_hc_view1 as select * from PG_DATABASE;
alter view hc.pg_hc_view1 rename to pg_hc_view5;
create user jim identified by ‘Test_@12345’;
alter view hc.pg_hc_view5 OWNER to jim;

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

create table hc.student
(student_id INTEGER,
student_name Char(30)
);
create view hc.student_view as select * from hc.student;
alter view hc.student_view set schema public;

3.使用pg_views查看视图信息

select * from pg_views where viewname=‘student_view’ or viewname=‘pg_hc_view5’;

4.删除视图、表、用户

drop view hc.pg_hc_view5;
drop view public.student_view;
drop table hc.student;
drop schema hc;
drop user jim;