课程作业

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

   CREATE VIEW db_view AS
   SELECT * FROM pg_database;

   alter view db_view rename to db_view_1;

   create user jim password 'abcd@123';

   alter view db_view_1 owner to jim;

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

   create table student(id int,name varchar(20));

   create view std_view as select * from student;

   alter view std_view set schema public;

3.使用pg_views查看视图信息

   select * from pg_views where viewname = 'db_view_1' or viewname = 'std_view';

4.删除视图、表、用户

   drop view db_view_1;
   drop view std_view;
   drop table student;
   drop user jim;