PG（HGDB）中创建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)