#opengauss的第六天打卡
创建一个名为tpcds的模式
omm=# create schema tpcds;
omm=# CREATE SCHEMA
创建一个用户tim, 并将tpcds的owner修改为tim，且修改owner前后分别使用\dn+查看模式信息
omm=# \dn+
List of schemas
Name | Owner | Access privileges | Description
-------------±------±------------------±---------------------------------
cstore | omm | | reserved schema for DELTA tables
dbe_perf | omm | | dbe_perf schema
pkg_service | omm | | pkg_service schema
public | omm | omm=UC/omm +| standard public schema
| | =U/omm |
snapshot | omm | | snapshot schema
tim | tim | |
tpcds | omm | |
omm=# alter schema tpcds owner to tim;
omm=# ALTER SCHEMA
omm=# \dn+
List of schemas
Name | Owner | Access privileges | Description
-------------±------±------------------±---------------------------------
cstore | omm | | reserved schema for DELTA tables
dbe_perf | omm | | dbe_perf schema
pkg_service | omm | | pkg_service schema
public | omm | omm=UC/omm +| standard public schema
| | =U/omm |
snapshot | omm | | snapshot schema
tim | tim | |
tpcds | tim | |
omm=# (7 rows)
重命名tpcds为tpcds1
alter schema tpcds rename to tpcds1;
ALTER SCHEMA
omm=# \dn
List of schemas
Name | Owner
-------------±------
cstore | omm
dbe_perf | omm
pkg_service | omm
public | omm
snapshot | omm
tim | tim
tpcds1 | omm
在模式tpcds1中建表customer、插入记录和查询记录
omm=# create table tpcds1.customer(id bigint,name char(40));
CREATE TABLE
omm=# insert into tpcds1.customer values(1,‘zhangsam’);
INSERT 0 1
omm=# insert into tpcds1.customer values(2,‘zhanglisi’);
INSERT 0 1
^
omm=# select * from pcds1.customer;tpcds1.customer;
id | name
----±-----------------------------------------
1 | zhangsam
2 | zhanglisi
(2 rows)
删除模式tpcds1
omm=# \dn
List of schemas
Name | Owner
-------------±------
cstore | omm
dbe_perf | omm
pkg_service | omm
public | omm
snapshot | omm
tim | tim
tpcds1 | omm
(7 rows)
omm=# drop schema tpcds1;
ERROR: cannot drop schema tpcds1 because other objects depend on it
DETAIL: table tpcds1.customer depends on schema tpcds1
HINT: Use DROP … CASCADE to drop the dependent objects too.
omm=# drop schema tpcds1 cascade;
NOTICE: drop cascades to table tpcds1.customer
DROP SCHEMA
omm=# \dn
List of schemas
Name | Owner
-------------±------
cstore | omm
dbe_perf | omm
pkg_service | omm
public | omm
snapshot | omm
tim | tim
