openGauss每日一练第9天 - 学习心得体会

1.创建表空间newtbs1

create tablespace newtbs1 relative location 'tablespace/newtbs1';

2.创建3个数据库newdb1、newdb2、newdb3，默认表空间为newtbs1

create database newdb1 with tablespace =newtbs1;
create database newdb2 with tablespace =newtbs1;
create database newdb3 with tablespace =newtbs1;

3.使用sql查看表空间newtbs1上有几个数据库

select datname,dattablespace,spcname from pg_database d, pg_tablespace t where d.dattablespace=t.oid and spcname='newtbs1' ;

4.在文件系统中查看表空间newtbs1中的多个数据库

select oid,datname from pg_database;select oid,* from pg_tablespace ;
\qcd /var/lib/opengauss/data/pg_tblspc
lsls 16463/PG_9.2_201611171_gaussdb