openGauss每日一练第 11 天

原创蓝图赵 2022-12-04

177

1.创建表空间enmtbs和数据库musicdb

Create tablespace enmtbs relative location ‘tablespace_enmtbs1’;

Crate database musicdb with tablespace=enmtbs;

Select datname from pg_database;

Select datname,dattablespace from pg_database where datname=’musicdb;

Select oid,spcname from pg_tablespace where oid=16389;

\dn+ 或者 select catalog_name,schema_name,schema_owner from information_schema.schemata;

with my_tables(table_catalog, table_schema, table_name, table_type) as

( select table_catalog, table_schema, table_name, table_type

from information_schema.tables

 where table_schema not in (‘pg_catalog’, ‘information_schema’,‘dbe_perf’)
)

select * from my_tables;

Create tablespace my_ts relative location ‘tablespace/my_ts;

Alter database musicdb set tablespace my_ts;

Alter database musicdb rename to mysicdb1;

Create use myuser1 identified by ‘user1@ustb2020';

Alter user myuser1 sysadmin;

Alter database musicdb owner to user1;

Drop database musicdb1;

墨力计划 opengauss opengauss每日一练

最后修改时间：2022-12-06 19:53:10

「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」

关注作者