openGauss每日一练第6天|openGauss创建模式、修改模式属性和删除模式

1.创建一个名为tpcds的模式

create schema tpcds;
\dn+ tpcds;

2.创建一个用户tim, 并将tpcds的owner修改为tim，且修改owner前后分别使用\dn+查看模式信息

create user tim password 'Open_234';
ALTER SCHEMA tpcds OWNER TO tim;
\dn+ tpcds;

3.重命名tpcds为tpcds1

alter schema tpcds rename to tpcds1;
\dn+ ;

4.在模式tpcds1中建表customer、插入记录和查询记录

create table tpcds1.customer(product_id INTEGER,product_name Char(20),category Char(10));
insert into tpcds1.customer(product_id,product_name,category) values
(1601,'lamaze','toys'),
(1700,'wait interface','Books'),
(1666,'harry potter','toys');
select * from tpcds1.customer;
\dt tpcds1.customer

5.删除模式tpcds1

drop schema tpcds1 cascade;

drop user tim;