openGauss每日一练第9天-oid

1.创建表空间newtbs1

omm=# create tablespace newtbs1 relative location 'tablespace/newtbs1';
CREATE TABLESPACE

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

omm=# CREATE DATABASE newdb1  WITH TABLESPACE = newtbs1;
CREATE DATABASE
omm=# CREATE DATABASE newdb2  WITH TABLESPACE = newtbs1;
CREATE DATABASE
omm=# CREATE DATABASE newdb3  WITH TABLESPACE = newtbs1;
CREATE DATABASE

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

omm=# select oid,* from pg_tablespace ;
  oid  |  spcname   | spcowner | spcacl | spcoptions | spcmaxsize | relative 
-------+------------+----------+--------+------------+------------+----------
  1663 | pg_default |       10 |        |            |            | f
  1664 | pg_global  |       10 |        |            |            | f
 16389 | music_tbs  |       10 |        |            |            | t
 16390 | newtbs1    |       10 |        |            |            | t
(4 rows)

omm=# select oid,datname from pg_database where dattablespace='16390';
  oid  | datname 
-------+---------
 16391 | newdb1
 16392 | newdb2
 16393 | newdb3
(3 rows)

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

omm@modb:/var/lib/opengauss/data/pg_tblspc/16390/PG_9.2_201611171_gaussdb$ ls
16391  16392  16393  pgsql_tmp