修改模式屬性
更新時間 2025-02-14 10:21:28
最近更新時間: 2025-02-14 10:21:28
分享文章
本文為您介紹如何修改模式屬性。
修改模式名
teledb=# alter schema teledb_schema rename to teledb_schema_new;
ALTER SCHEMA修改所有者
teledb=# \dn teledb_schema_new
List of schemas
Name | Owner
--------------------+---------
teledb_schema_new | teledb
(1 row)
teledb=# alter schema teledb_schema_new owner to teledb_user;
ALTER SCHEMA
teledb=# \dn teledb_schema_new
List of schemas
Name | Owner
--------------------+--------------
teledb_schema_new | teledb_user
(1 row)
