本文演示了使用highgo数据库管理系统创建、修改所有者及重命名Schema的操作过程。通过实际案例展示了如何利用SQL命令来有效管理数据库Schema，包括查看当前存在的Schema及其所有者信息。
highgo=# create schema test;
CREATE SCHEMA
highgo=# \dn
List of schemas
Name | Owner
----------------+--------
hgdb_catalog | highgo
oracle_catalog | highgo
public | highgo
test | test
(4 rows)
highgo=# alter schema test owner to highgo; ---修改schema的属主
ALTER SCHEMA
highgo=# \dn
List of schemas
Name | Owner
----------------+--------
hgdb_catalog | highgo
oracle_catalog | highgo
public | highgo
test | highgo
(4 rows)
highgo=# alter schema test rename to testa; --修改schema的名称
ALTER SCHEMA
highgo=# \dn
List of schemas
Name | Owner
----------------+--------
hgdb_catalog | highgo
oracle_catalog | highgo
public | highgo
testa | highgo
(4 rows)
highgo=# create schema test authorization highgo;;
CREATE SCHEMA
highgo=# \dn
List of schemas
Name | Owner
----------------+--------
hgdb_catalog | highgo
oracle_catalog | highgo
public | highgo
test | highgo
(4 rows)
CREATE SCHEMA
highgo=# \dn
List of schemas
Name | Owner
----------------+--------
hgdb_catalog | highgo
oracle_catalog | highgo
public | highgo
test | test
(4 rows)
highgo=# alter schema test owner to highgo; ---修改schema的属主
ALTER SCHEMA
highgo=# \dn
List of schemas
Name | Owner
----------------+--------
hgdb_catalog | highgo
oracle_catalog | highgo
public | highgo
test | highgo
(4 rows)
highgo=# alter schema test rename to testa; --修改schema的名称
ALTER SCHEMA
highgo=# \dn
List of schemas
Name | Owner
----------------+--------
hgdb_catalog | highgo
oracle_catalog | highgo
public | highgo
testa | highgo
(4 rows)
highgo=# create schema test authorization highgo;;
CREATE SCHEMA
highgo=# \dn
List of schemas
Name | Owner
----------------+--------
hgdb_catalog | highgo
oracle_catalog | highgo
public | highgo
test | highgo
(4 rows)
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
