openGauss每日一练第11天: 视图的使用

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

    create view v_pg_database_v2 as select * from pg_database;

    alter view  v_pg_database_v2 rename to  v_pg_database_v1;

    create user jim identified by 'test_1234';

    alter view v_pg_database_v1 owner to jim;

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

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

    insert into student values(1,'job'),(10,'luby'),(14,'jock');

    create view v_student_v1 as select * from student where id>10;

    create schema test;

   alter view v_student_v1 set schema test;

3.使用pg_views查看视图信息

4.删除视图、表、用户

    drop view v_pg_database_v1;

    drop view test.v_student_v1;

    drop table student;

    drop user jim;