修改模式属性
更新时间 2025-02-14 10:21:48
最近更新时间: 2025-02-14 10:21:48
本文为您介绍如何修改模式属性。
修改模式名
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)
