openGauss每日一练第 8天

1.创建表空间newtbs1、 ds_location1，查看表空间

create tablespace newtbs1 relative location 'tablespace/newtbs1';
create tablespace ds_location1 relative location 'tablespace/ds_lacation1';

2.创建一个数据库newdb1，默认表空间为newtbs1

create database newdb1 with tablespace=newtbs1;

3.创建用户user5，并授予SYSADMIN权限，访问数据库newdb1，在表空间ds_location1上，创建一个表newt1（表结构自定义）

create user user5 identified by 'zuoye@1234';alter user user5 sysadmin;\c newdb1 user5create table newt1(col1 char(20)) tablespace ds_location1;

4.查看表所在的表空间

select * from pg_tables where tablename = 'newt1';

5.查看表空间newtbs1、 ds_location1上的对象

select relname, relkind, relpages,pg_size_pretty(pg_relation_size(a.oid)),reltablespace,relowner  
from pg_class a, pg_tablespace tb  
where a.relkind in ('r', 'i')  
and a.reltablespace=tb.oid  
and tb.spcname='newtbs1'  
order by a.relpages desc;
select relname, relkind, relpages,pg_size_pretty(pg_relation_size(a.oid)),reltablespace,relowner  
from pg_class a, pg_tablespace tb  
where a.relkind in ('r', 'i')  
and a.reltablespace=tb.oid  
and tb.spcname='ds_location1'  
order by a.relpages desc;